Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 22nd January 2006, 22:01
Gem Gem is offline
Junior Member
 
Join Date: Jan 2006
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
Default MySQL - The Perfect Set Up Fedora Core 4

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
Reply With Quote
Sponsored Links
  #2  
Old 22nd January 2006, 22:31
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,001
Thanks: 840
Thanked 5,650 Times in 4,460 Posts
Default

Quote:
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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 22nd January 2006, 22:48
Gem Gem is offline
Junior Member
 
Join Date: Jan 2006
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I got this error after typing in

Code:
 /etc/init.d/mysqld start
edits to add I am still getting the 1064 error

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

Last edited by Gem; 22nd January 2006 at 23:58.
Reply With Quote
  #4  
Old 23rd January 2006, 00:12
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,749 Times in 2,579 Posts
Default

Quote:
Originally Posted by Gem
edits to add I am still getting the 1064 error

Code:
 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?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #5  
Old 23rd January 2006, 00:42
Gem Gem is offline
Junior Member
 
Join Date: Jan 2006
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I used

Code:
mysqladmin -root password mypasswordhere
I also tried

Code:
SET PASSWORD FOR root = PASSWORD("mypassword");
and got the same error...
Reply With Quote
  #6  
Old 23rd January 2006, 07:04
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,749 Times in 2,579 Posts
Default

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

The correct command is
Code:
mysqladmin -u root password yourrootsqlpassword
, not

Code:
mysqladmin -root password yourrootsqlpassword
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #7  
Old 23rd January 2006, 13:36
Gem Gem is offline
Junior Member
 
Join Date: Jan 2006
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

Code:
mysqladmin -u root password yourrootsqlpassword
I even tried it again to make sure and I am getting the same error...
Reply With Quote
  #8  
Old 23rd January 2006, 18:51
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,749 Times in 2,579 Posts
Default

Have a look at this thread: http://www.howtoforge.com/forums/showthread.php?t=1581
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #9  
Old 24th January 2006, 01:14
Gem Gem is offline
Junior Member
 
Join Date: Jan 2006
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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:

Code:
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

Code:
 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*
Reply With Quote
  #10  
Old 24th January 2006, 09:52
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,749 Times in 2,579 Posts
 
Default

Is MySQL listening on localhost? Please post the output of
Code:
netstat -tap
What's in /etc/hosts?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

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 On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Fedora Core 4 - The Perfect Setup nandhu HOWTO-Related Questions 27 10th January 2006 13:23
Few questions about Fedora core 4 perfect setup + mantasman HOWTO-Related Questions 3 9th January 2006 23:22
The Perfect Setup - Fedora Core 4 amdserver HOWTO-Related Questions 42 9th November 2005 14:48
The Perfect Setup Fedora Core 4 Proftpd error Nu2Linux HOWTO-Related Questions 3 29th October 2005 21:26
Quota: Perfect Setup Fedora Core 4 domino Installation/Configuration 7 20th August 2005 18:42


All times are GMT +2. The time now is 02:20.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.