| tronayne |
06-24-2011 07:17 AM |
If
Code:
mysql_secure_installation
was executed, "You can remove root accounts that are accessible from outside the local host."
So, if you're trying to access a remote machine, that's the problem (you can't).
Otherwise, either (1) there is no password set (so don't use -p on the command line) or (2) you don't have the correct password.
If you can connect to the mysql data base, e.g., "use mysql," try
Code:
mysql> select host, user, password from user;
and see what you get -- a system without a root password will look like this
Code:
mysql> select host, user, password from user;
+-----------+--------+-------------------------------------------+
| host | user | password |
+-----------+--------+-------------------------------------------+
| localhost | root | |
| fubar | root | |
| 127.0.0.1 | root | |
| localhost | | |
| fubar | | |
| localhost | trona | *3E473C392738635BB3C40B77F339AE2B5B96AB5F |
| % | trona | *3E473C392738635BB3C40B77F339AE2B5B96AB5F |
| localhost | gnis | *810EB1988696641613BC905C437D48DB0286A594 |
| % | gnis | *810EB1988696641613BC905C437D48DB0286A594 |
| localhost | bugs | *20F70E9EB731F79D181E637A46E64D7E1050F956 |
| % | bugs | *20F70E9EB731F79D181E637A46E64D7E1050F956 |
| localhost | ged | *4CA8F8F4B8B5DCC12808D5AE020BCCB3E522CCA6 |
| % | ged | *4CA8F8F4B8B5DCC12808D5AE020BCCB3E522CCA6 |
| localhost | ipplan | *EDA2B4CA7C3B7D3287C8DB2EA4850DFB25D9ED41 |
| % | ipplan | *EDA2B4CA7C3B7D3287C8DB2EA4850DFB25D9ED41 |
+-----------+--------+-------------------------------------------+
15 rows in set (0.00 sec)
whereas a system with a root password will look like this
Code:
mysql> select host, user, password from user;
+-----------+--------+-------------------------------------------+
| host | user | password |
+-----------+--------+-------------------------------------------+
| localhost | root | *3E473C392738635BB3C40B77F339AE2B5B96AB5F |
| 127.0.0.1 | root | *3E473C392738635BB3C40B77F339AE2B5B96AB5F |
| localhost | trona | *3E473C392738635BB3C40B77F339AE2B5B96AB5F |
| % | trona | *3E473C392738635BB3C40B77F339AE2B5B96AB5F |
| localhost | gnis | *810EB1988696641613BC905C437D48DB0286A594 |
| % | gnis | *810EB1988696641613BC905C437D48DB0286A594 |
| localhost | bugs | *20F70E9EB731F79D181E637A46E64D7E1050F956 |
| % | bugs | *20F70E9EB731F79D181E637A46E64D7E1050F956 |
| localhost | ged | *4CA8F8F4B8B5DCC12808D5AE020BCCB3E522CCA6 |
| % | ged | *4CA8F8F4B8B5DCC12808D5AE020BCCB3E522CCA6 |
| localhost | ipplan | *EDA2B4CA7C3B7D3287C8DB2EA4850DFB25D9ED41 |
| % | ipplan | *EDA2B4CA7C3B7D3287C8DB2EA4850DFB25D9ED41 |
+-----------+--------+-------------------------------------------+
12 rows in set (0.00 sec)
Hope this helps some. |
