One of my proactive management customers came up to me today with an issue he’s been having on one of his cPanel/WHM servers: he has been trying to add a user to a database he created and he received this error:
The system received an error from the “MySQL” database “mysql”: ER_PASSWORD_NO_MATCH (Can’t find any matching row in the user table)
Apparently commenting out skip-name-resolve in /etc/my.cnf fixed it.
then run a MySQL server restart with: /scripts/restartsrv_ mysql and you should be good to go.
I am just setting a new server up, and i upgraded apache first. Now i went to upgrade MySQL to 5.5, but when i am going in the interface, it says:
WARNING: A running easyapache process was detected. Please wait for easyapache to finish before attempting to upgrade MySQL.
If you are certain that the easyapache is no longer running, you may restart the MySQL upgrade by clicking the following button.
The “Ignore current upgrade button” is not working. What do we do?
What you can do, is to run:
ps aux | grep easyapache
If it doesn’t return any process running, then go delete the following file:
Okay, i just came onto this today, and i find it highly useful to get an sql database usage at a glance:
SELECT table_schema “Data Base Name”, SUM( data_length + index_length) / 1024 / 1024
“Data Base Size in MB” FROM information_schema.TABLES GROUP BY table_schema ;
LE: If you want to see the size of the tables in a certain db:
SELECT table_name AS “Tables”, round(((data_length + index_length) / 1024 / 1024), 2) “Size in MB” FROM information_schema.TABLES WHERE table_schema = “your_database_name”;
MySQL Add User FAQ: How do I add a user to MySQL (i.e., how do I create a MySQL user account)?
MySQL add user – solution
Solution: Here’s an example of what I did recently to (a) create a new MySQL database and then (b) add a new MySQL user account to work with that database. As usual, the database name, username, and password have been changed.
First, from my Unix prompt, I log into my MySQL database with the mysql command line client:
unix> mysql -u root -p
(here I enter ‘my_root_password’ to get through the mysql prompt)
Next, I create my new MySQL database with the “create database” command:
mysql> create database my_database;
And now I create a MySQL user account, giving the user account all the priviliges it needs to “own” this database, with the MySQL grant command. Note that I assign both the username and password when I add this MySQL user:
mysql> GRANT ALL PRIVILEGES
IDENTIFIED BY ‘my_password’
WITH GRANT OPTION;
Am terminat cursul intr-un sfarsit. Clicky poza.
Azi m-am trezit la 5, ca orice om normal care se trezeste la 5. Yea, real fun i know. Anyways, azi sper sa termin ultimele capitole de php/mysql de pe lynda.com, si trebuie sa completez aplicatia, asa ca va delectati doar cu 1 melodie si 1 trailer – chestii aleeeese pe spranceana. Voi distractie – eu work, si ne revedem un pic mai incolo, dupa ce o sa fiu mandru de mine.
Next project – bring Frankenstein back to life.