-   Linux - Newbie (
-   -   Unable to reset the root password for mysql on fedora (

cll975dll 08-07-2009 10:12 AM

Unable to reset the root password for mysql on fedora
I have successfully installed mysql on my fedora machine and started up the server also. To get a firm knowledge about the installation and configuration of mysql, I deliberately uninstalled it using YUM. Now when second time I have installed mysql I am unable to set the root password using
/usr/bin/mysqladmin-u root password 'new password'

I have deleted the entry for mysql from /etc/passwd. Now when it is not allowing me to install mysql totally
1) What is the problem and how to solve it?
2) Where the installatin files are stored on linux as in Windows they are stored by default on c:?
3) What are /etc/rc.d and /etc/rc.d/init.d directories used for?

Any help will be appreciated.
thanx in advance>

jstephens84 08-08-2009 09:47 PM

I would start by adding the mysql user back to the passwd file. This users is different and is used to control the mysql daemon.

to reset the lost password. do the following

1. stop the mysql server.
2. start the mysql with the following

mysqld_safe --skip-grant-tables &
3. connect to mysql

mysql -u root
4. use mysql database
5. use the following query

update user set password=PASSWORD('new password') where user=root
6 Now flush the privileges and quit

flush privileges

7. stop mysql
8. Now restart mysql in normal mode

/etc/init.d/mysqld start
and that should get your going again.

All times are GMT -5. The time now is 09:27 PM.