LinuxQuestions.org
Latest LQ Deal: Linux Power User Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
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.

Notices


Reply
  Search this Thread
Old 11-03-2003, 10:08 AM   #1
bkimelman
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 :



mysql_install_db



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

setups.



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
devinWhalen
Member
 
Registered: Apr 2003
Location: Toronto, Canada
Distribution: Red Hat, openBSD,Mandrake,freeBSD,SunOS
Posts: 168

Rep: Reputation: 30
Hey,

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
IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

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

Later
 
  


Reply


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


All times are GMT -5. The time now is 12:58 PM.

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