igotnoluck Posted May 11, 2008 Report Share Posted May 11, 2008 Hi all, well i'm trying to install mysql 5.0 on my mdv 2008.1 machine. the installation guide i'm working with is: Howtofordge -mdv2008.1 server everything is working perfect in the installation part until I reach this commands: if I type this: mysqladmin -u root password yourrootsqlpassword I get the following error: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' if I try the following command: mysqladmin -h server1.example.com -u root password yourrootsqlpassword (after changing my hostname and changing the server1.example.com to my hostname) the error is: mysqladmin: connect to server at 'myhostname' failed error: 'Host 'myhostname' is not allowed to connect to this MySQL server' I checked the following: * firewall is open on port 3306 (i even checked with no firewall) * the my.cnf file is as it came by default after changing only what the guide said please help me :) thanks Quote Link to comment Share on other sites More sharing options...
SilverSurfer60 Posted May 12, 2008 Report Share Posted May 12, 2008 Without writing a quite long howto I will try and explain what it is you are attempting. To help you, if you enter mysqladmin --help on the command line you will get quite a comprehensive list of commands and options. Also there is a man page which explains even more. To get you on your way the first command to enter is mysqladmin -u root --password yourrootsqlpassword Please note the -- before password. With this command you are setting the password for root, out of the box mysql does not have a password set. In the second command sequence until you have configured the server to run on your network it is always run on 'localhost'. To make life easier for you there is an RPM in the repos call mysqladministrator, which is a graphical frontend for just what you are doing. For even further information the website http://www.mysql.com/ has all the docs online for most of the versions available, beware though because mysql is a very complicated and powerful database machine. If that is not enough there are forums on the subject as well accessible from their home page. Good Luck Quote Link to comment Share on other sites More sharing options...
igotnoluck Posted May 12, 2008 Author Report Share Posted May 12, 2008 thanks for the reply but iff i add the -- to the password and run the command mysql ask me to enter a password and each password i try (including blank) is givinig this error: [root@localhost nimrod]# mysqladmin -u root --password mypassword Enter password: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)' Quote Link to comment Share on other sites More sharing options...
SilverSurfer60 Posted May 12, 2008 Report Share Posted May 12, 2008 Sorry my mistake there it's been a while since I went through all this. Try connecting to the server without a password. i.e. mysqladmin -u root If no password has been set you should connect. If you get an error then a password has been set. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.