#1  
Old 7th June 2010, 11:53
Pashy Pashy is offline
Junior Member
 
Join Date: Jun 2010
Posts: 11
Thanks: 2
Thanked 0 Times in 0 Posts
Default MySql error 1044 (fedora 11)

Hi folks,
I am installing MySql on Linux (Fedora core 11). Basically I am newbie & wana create a PHP application. I am done with PHP & Apache installation.
I am facing some serious problems while Installing Mysql.
below are all the tried codes & the outputs/errors:
#yum install mysql mysql-server
#chkconfig --levels 235 mysqld on
#/etc/init.d/mysqld start
#mysqladmin -u root password yourrootsqlpassword

in my case which exactly looks like
# mysqladmin -u root 'root_password' 'newroot_password'
the output is
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

Here I am confused abt the root password, as to what password exactly I have to enter here. Since I had never set a password for Mysql as far as I remember. I had removed & reinstalled the MySql packages.
Then I even tried:
#mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Folks I have tried all possibilities that were mentioned on the Internet & various forums.
Can anyone kindly help me out with the detailed & easliy understandable steps
e.g if the command is :
# mysqladmin -u root password new-password
then what actually I have to enter after root "word password" or "actual_password"
Hope I am able to convey my doubt properly.

However I am able to get into the Mysql prompt with the below code:
#mysql -user=root
but not able to execute the commands like:
mysql> create database salesdata;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'salesdata'

Can anyone plz reply to this on priority.

Thanks in advance..!
Reply With Quote
Sponsored Links
  #2  
Old 7th June 2010, 13:14
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,411
Thanks: 834
Thanked 5,496 Times in 4,326 Posts
Default

Your mysql server seems to have a rootpassword, so the commands above do not work as they assume that no root password has been set before. To reset your root password, see here:

http://www.faqforge.com/linux/contro...root-password/

reinstalling mysql that you tried above can not work as the root password is not reset on reinstall.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 8th June 2010, 03:28
Pashy Pashy is offline
Junior Member
 
Join Date: Jun 2010
Posts: 11
Thanks: 2
Thanked 0 Times in 0 Posts
Thumbs up

Hey Till,

You are a super genius, after trying for hours long I couldn't
fix the problem but your reply solved it in 1 min..

Except the location of MySql daemon everything was perfect in your
reply
i.e. /etc/rc.d/init.d/mysqld start

Thanks a Ton..
Reply With Quote
  #4  
Old 8th June 2010, 05:01
Pashy Pashy is offline
Junior Member
 
Join Date: Jun 2010
Posts: 11
Thanks: 2
Thanked 0 Times in 0 Posts
Default Mysql error --skip-grant-tables

Hi Till,

Thank you.

But I am facing a problem after skipping the grant-tables as instructed in your reply.
Code :
mysqld_safe --skip-grant-tables &

I have created a Database "hello" and I am trying to give some privileges to user 'pashy'.
code:
mysql> grant all privileges on hello.* to Pashy@"TestServer" identified by 'Pashy';
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

please kindly help..
Reply With Quote
  #5  
Old 8th June 2010, 15:38
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,744 Times in 2,577 Posts
 
Default

Please try steps 4 and 5 of http://www.faqforge.com/linux/contro...root-password/ and try again.
__________________
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
Load balancing on Fedora with Heartbeat (MySQL Cluster) rwillie6 HOWTO-Related Questions 7 17th December 2009 12:32
ISPConfig3 Mail Warn Errors reason8 General 3 25th November 2009 13:58
Problem Installing Apache 2.2.8, MySQL 5.0 Client and PHP 5.2.5 On Fedora 8 (64-Bit) asyadiqin Installation/Configuration 5 10th April 2008 18:40
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04


All times are GMT +2. The time now is 18:06.


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