Jump to content

installing mysql on 2008.1


igotnoluck
 Share

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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)'

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...