Setting password for mysql root user.

[BrandonV]

Ok im three days new to linux, I installed fedora core 4 and have Fedora 4 unleashed as my guide. I have set up an FTP server with 10 accounts and I have apache running. Now I want to get sql going to I can start developing my web page.

In my book it says to type

mysql -u root

then it says to

mysql> SET PASSWORD FOR root = PASSWORD("yournewpasswordhere");

After i type that I get an error that says

ERROR 1133 (42000): Can't find any matching row in the user table

any insight on what is wrong or what im doing wrong?

[BrandonV]

also I searc and only found this thread

http://forums.fedoraforum.org/forum/...earchid=972126

but was no help

[bytesniper]

1) make sure mysqld is running: service mysqld status
2) if there is not yet a password set then when you just type mysql and hit enter it should log you in with an unprivledged (usage only) user. type show databases; and make sure you have the 'mysql' database.
3) try using mysqladmin -u root password <my_password> to change your password

hth,
Joseph

[BrandonV]

Originally Posted by bytesniper

1) make sure mysqld is running: service mysqld status
2) if there is not yet a password set then when you just type mysql and hit enter it should log you in with an unprivledged (usage only) user. type show databases; and make sure you have the 'mysql' database.
3) try using mysqladmin -u root password <my_password> to change your password

hth,
Joseph

mysql> show databases;
+----------+
| Database |
+----------+
| test |
+----------+
1 row in set (0.00 sec)


#3 didnt work

[bytesniper]

you should have another one in there called 'mysql' that holds, among many other things, the mysql user information. without it your not going to get anywhere at all. is this a version of mysql that you installed yourself or one that came with FC?

at this point i would recommend to uninstall it completely and reinstall it. other option is to find a default mysql.sql database that someone has mysqldump'ed or otherwise provided before any modifications were made to it.

[BrandonV]

Originally Posted by bytesniper

you should have another one in there called 'mysql' that holds, among many other things, the mysql user information. without it your not going to get anywhere at all. is this a version of mysql that you installed yourself or one that came with FC?

at this point i would recommend to uninstall it completely and reinstall it. other option is to find a default mbvandermeersch
mysqlysql.sql database that someone has mysqldump'ed or otherwise provided before any modifications were made to it.

Yea it came with FC4.

[bytesniper]

very strange. only clean mysql installation i have ever seen (from FC) that didnt come with the 'mysql' base. i think your in luck though becuase i just setup a box at work with an sql server i havent done anything with yet so i ssh'd into it and dumped the mysql base which you should be able to import and all should be well.

1) create the mysql database in mysql. in mysql console type create database mysql;
2) download the mysql.sql file i have attached and type: mysql mysql < mysql.sql which is [mysql {database} < {dumpfile.sql}]

then try to set your admin password using any of the methods preciously discussed.

(edit) apparently this board won't accept .sql file as uploads so i gz'd it. you'll have to extract it out after you get it. tar xzf mysqldump.tar.gz

hope this works for ya,
Joseph

[BrandonV]

read your last post to late, im doing a yum update to all my mysql packages and installing the updates right now.

if it dosent work then I will download your file.

thanks for all you help also, its much appreciated.

[BrandonV]

Dosent work when I goto create the database I get:
ERROR 1044 (42000): Access denied for user ' '@'localhost' to database 'mysql'

This is getting really frustrating.

[bytesniper]

even after using the sql file i uploaded?

[BrandonV]

Originally Posted by bytesniper

1) create the mysql database in mysql. in mysql console type create database mysql;
2) download the mysql.sql file i have attached and type: mysql mysql < mysql.sql which is [mysql {database} < {dumpfile.sql}]

then try to set your admin password using any of the methods preciously discussed.

Dosent work when I do the first step I get:
ERROR 1044 (42000): Access denied for user ' '@'localhost' to database 'mysql'