MySQL pisses me off! - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: MySQL pisses me off! (/showthread.php?tid=611890)

---

MySQL pisses me off! - bgedition - 11.07.2016

Hello,

So MySQL always gives me the same error #1045 - Access denied! with no reason.
When my server tries to connect to the localhost is showing this shitty error! I tried with different database usernames and always with correct passwords, but it just don't wants the server to connect!

please if someone knows what is wrong - let me know it!

---

Re: MySQL pisses me off! - Naruto_Emilio - 11.07.2016

- Stop MySQL
- Restart it manually with the skip-grant-tables option: mysqld_safe --skip-grant-tables
- Now, open a new terminal window and run the MySQL client: mysql -u root
- Reset the root password manually with this MySQL command: UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root'; If you are using MySQL 5.7 (check using mysql --version in the Terminal) then the command is:
UPDATE mysql.user SET authentication_string=PASSWORD('password') WHERE User='root';
- Flush the privileges with this MySQL command: FLUSH PRIVILEGES;

---

Re: MySQL pisses me off! - WhiteGhost - 11.07.2016

if it pisses u off,dont use it.
Do u like stress?

---

Re: MySQL pisses me off! - bgedition - 11.07.2016

I have to use it! I mostly am using the mysql like a 'bridge' for my website and the server! so I must use it

---

Re: MySQL pisses me off! - WhiteGhost - 11.07.2016

Oh,ik then well if u cant learn from samp tutorials view youtube tutorial.
Dont rush it,Take your time and learn it.

---

Re: MySQL pisses me off! - bgedition - 11.07.2016

Oh come on I know how to do the basic that's all I need. But I don't know the reason for this error! I can't find it!

---

Re: MySQL pisses me off! - bgedition - 11.07.2016

nevermind I'm the supid one here I swiched the password with the schema

---

Re: MySQL pisses me off! - Parallex - 15.07.2016

You are using that free 000 web host, right?

---