MYSQL:Access denied!!!!
:scratch: Hi all now am trying to install cacti and i followed the instructions quite easily. Now when i try to access the web interface i get the following error which is in relation to importing the defauldt cacti database to the mysql:
Code:
Error Quote:
While you guys are still at it could you give me the best way to uninstall mysql? cheers |
Your command is incomplete.
Try Code:
mysql -u root -p |
ok even with that it still asks for a password yet when i give it the password:
Code:
mysql> GRANT ALL ON cacti.* TO cactiuser@localhost IDENTIFIED BY 'me'; ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'cacti' |
have you ran the mysql_install_db and ran the mysqladmin -u root password 'password_here'
|
What jstephens84 means is that you may not have run the commands to initially set up the mysql root passwords. You should run both of these, if you haven't already:
Code:
mysqladmin -u root -h 'hostname' password 'password' |
the mysql_install_db also installs the system database and setups up the permissions. So at this point in time root may not have the appropriate permissions.
|
Quote:
Quote:
...And for the second one: Quote:
|
what do you get when you run
Code:
mysqladmin -u root password '<your password>' |
All times are GMT -5. The time now is 11:36 PM. |