Download your favorite Linux distribution at LQ ISO.
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 11-03-2003, 10:08 AM   #1
LQ Newbie
Registered: Sep 2003
Location: Winnipeg, Manitoba, Canada
Posts: 3

Rep: Reputation: 0
Question Linux newbie needs help with install of MySQL on Redhat9

I am running Redhat Linux 9 on my laptop. The kernel version is 2.4.20-8

I installed the packages for MySQL from the 3 CDs I used to install

Redhat9 itself. The install went throught without any problems.

Next, according to the MySQL documentation I performed the following

"Post-installation Setup and Testing" commands :


# Note : I saw the expected messages; mesages pertaining to table


safe_mysqld --user=mysql &

# Note : The mysql processes were successfully started

mysqladmin version

# I saw the expected output

# Next I attempted to set a password for the root USER

# as described in the output from the mysql_install_db command

mysqladmin -u mysql password newpass

# I received the following error message

mysqladmin: unable to change password; error: 'Acccess denied for user:

'@localhost' to database 'mysql''

My question is, what have I done wrong?

Is the "MySQL root USER" mentioned in the output of the mysql_install_db

command the unix user "mysql" who owns the directory where the various

files reside or perhaps some other UNIX user (perhaps even root itself)


How and when do you specify the "MySQL root USER" ??

TIA for all your help.
Old 11-03-2003, 11:28 AM   #2
Registered: Apr 2003
Location: Toronto, Canada
Distribution: Red Hat, openBSD,Mandrake,freeBSD,SunOS
Posts: 168

Rep: Reputation: 30

I remember having the same problems when I first installed mysql....however I can't remember the solution

But try this:
su root

start up mysql:
/etc/rc.d/init.d/mysqld start

Then connect from the command line....but don't use a password:
mysql -u root mysql

Then create a user
GRANT ALL PRIVILEGES ON *.* TO user@localhost

The some_pass is the password you want.
If you want to connect remotely then you have to add an ip in place of localhost

You should also change the root user password:
SET PASSWORD FOR root = PASSWORD('password');

You know what, I may be confused with postgresql where you connect up with the linux users. I think mysql distinguishes between the system users and the database users. So, if connecting with root does not work. Try the user mysql. So:
mysql -u mysql mysql

You can leave off the mysql at the end. This is the database name. Make sure you change the mysql users password so your database will be secure.
SET PASSWORD FOR mysql = PASSWORD('password');

Hope this was helpful. If I was confusing just let me know



Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Newbie with MySQL Install problem pendulum Linux - Newbie 3 04-12-2005 11:59 PM
How to install mysql on Xandros 2.0 for Newbie jdruin Linux - Software 1 07-03-2004 03:15 PM
mysql question (w/ redhat9) monzlin Linux - Software 2 05-08-2004 04:18 PM
How to configure mysql on a fresh redhat9 install? unclean Linux - Software 0 01-30-2004 03:42 PM
Newbie MySQL install help andweave Linux - Software 3 06-27-2002 06:37 AM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 02:36 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration