Posts: 417
Threads: 40
Joined: Oct 2013
Reputation:
0
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!
Posts: 1,297
Threads: 17
Joined: Apr 2011
- 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;
if it pisses u off,dont use it.
Do u like stress?
Posts: 417
Threads: 40
Joined: Oct 2013
Reputation:
0
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
Oh,ik then well if u cant learn from samp tutorials view youtube tutorial.
Dont rush it,Take your time and learn it.
Posts: 417
Threads: 40
Joined: Oct 2013
Reputation:
0
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!
Posts: 417
Threads: 40
Joined: Oct 2013
Reputation:
0
nevermind I'm the supid one here I swiched the password with the schema