Go Back   TechArena Community > Software > Operating Systems
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



mysql root account password

Operating Systems


Reply
 
Thread Tools Search this Thread
  #1  
Old 28-07-2009
Member
 
Join Date: Jul 2009
Posts: 19
mysql root account password
  

I am trying to install mysql on an older box. I want to try out the XOOPS features on this old distribution. I have this machine running with Fedora 6. When i try to log into my sql buy this command :
Code:
mysqladmin -u mysql -p create xoops4
I get a password prompt. But i have not password protected it. How did the password prompt come? Can anyone help me get through it? Thanks in advance...

Reply With Quote
  #2  
Old 28-07-2009
Member
 
Join Date: May 2008
Posts: 4,083
Re: mysql root account password

Try to login with root by entering this command at console :
Code:
mysql -u root -p
If you are prompted for a password then you will need to add a password. Use this command :
Code:
mysqladmin -u root password 'enter-pass-here'
Then again try to login as root :
Code:
mysql -u root -p
Then enter the new pass and create database and add users...
Reply With Quote
  #3  
Old 28-07-2009
Member
 
Join Date: Jul 2009
Posts: 19
Re: mysql root account password

Still on the same problem. I cannot get through mysql :
Code:
# mysqladmin -u root -p status
Enter password:
mysqladmin: connect to server
at 'localhost' failed
error: 'Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
Reply With Quote
  #4  
Old 28-07-2009
Member
 
Join Date: Apr 2008
Posts: 3,516
Re: mysql root account password

Go to console and enter the following command :
Code:
mysql -u root -p -h localhost
This will get you through... The mysql server takes some assumptions if you do not provide correct parameters.. Hope this works for you..
Reply With Quote
Reply

  TechArena Community > Software > Operating Systems
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "mysql root account password"
Thread Thread Starter Forum Replies Last Post
Mysql Error : Can't connect to local mysql server through socket ' var lib mysql mysql.sock' 2 roshan45 Software Development 3 07-11-2009 08:36 PM
What is the mysql default password ? avit Software Development 3 11-09-2009 05:42 PM
How to reset mysql password? Yarn Software Development 2 23-05-2009 06:04 PM
How to change password in MySQL? Tweaker Software Development 2 20-10-2008 04:47 PM
Change password/disable account - password cached? gbug Active Directory 3 25-04-2008 05:09 AM


All times are GMT +5.5. The time now is 03:53 PM.