YamiHoshi.nl

On every Debian-based VPS, I get this error message after “mysql -u root -p”.
But how to solve the case?
Here’s the tutorial.

On Debian servers, MySQL doesn’t come with a Root user.
Even though you make a Root user, you’ll still won’t be able to do anything.
Instead, look in your Debian.conf.

nano /etc/mysql/debian.conf

Copy the username and password over to your Text Editor.
And now, log in:

mysql -u username-in-your-conf -ppassword-in-your-conf

Yes, “-p” and the password without spaces.
And you’re in, and you can do anything you want!