MySQL - The Perfect Set Up Fedora Core 4

[Gem]

Hello..

I am in the process of setting up my server and am having a problem with the install for MySQL....I have followed the directions as posted and these are the errors that I am getting...

ERROR: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
060122 14:18:09 [ERROR] Aborting

and when trying to set the password for root I am getting this error...

error: 'Access denied for user 'root'@'localhost' (using password: NO)'

MySQL starts and stops OK, and I have even started the whole install of Fedora over and am getting the same errors...I have goggled to see what I can do to fix the problem, but can not seem to find anything.

Any help would be appreciated.

Thanks

[till]

Originally Posted by Gem

ERROR: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
060122 14:18:09 [ERROR] Aborting

When exactly did you get this error. Please post the command that results in this error.

[Gem]

I got this error after typing in

 /etc/init.d/mysqld start

edits to add I am still getting the 1064 error

 mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

[falko]

Originally Posted by Gem

edits to add I am still getting the 1064 error

 mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

What's the exact command you ran that gave you this error?

[Gem]

I used

mysqladmin -root password mypasswordhere

I also tried

SET PASSWORD FOR root = PASSWORD("mypassword");

and got the same error...

[falko]

Have a look here: http://www.howtoforge.com/perfect_se...dora_core_4_p4

The correct command is

mysqladmin -u root password yourrootsqlpassword

, not

mysqladmin -root password yourrootsqlpassword

[Gem]

I'm sorry, that was a typo on my part, I was using the comand

mysqladmin -u root password yourrootsqlpassword

I even tried it again to make sure and I am getting the same error...

[falko]

Have a look at this thread: http://www.howtoforge.com/forums/showthread.php?t=1581

[Gem]

I have read the thread that you posted and I am not sure that it really is going to help me. I have not tried to install ISPConfig yet because of the MySQL error that I am getting, plus the error that user was getting was:

ERROR:1045: Access denied for user:'root@localhost' (Using password:YES)
ERROR: The provided MySQL password is wrong! The installation routine stops here!

Mine is

 mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

I have not been able to create a password for root. I have tried to unistall MySQL to start over and it wont let me because of PHP, and that was before I got to the part of the install steps in the tut on PHP.

I have even gone as far as starting completly over with a fresh install of Fedroa and am still getting the same error. I am at a loss...and it is getting so frusterating....got to love it though...*grin*

Thanks for taking the time out and answering my questions...*S*

[falko]

Is MySQL listening on localhost? Please post the output of

netstat -tap

What's in /etc/hosts?