#1  
Old 21st January 2011, 22:04
newbie14 newbie14 is offline
Member
 
Join Date: Jul 2010
Posts: 59
Thanks: 0
Thanked 0 Times in 0 Posts
Default Missing mysql database

Dear All,
I have new centos 5.5 machine then I yum install mysql mysql-server. Then I run mysql -u root. So I tried show databases just shows me one database that is information schema. So I can not change my root password. How go to about it? Thank you.
Reply With Quote
Sponsored Links
  #2  
Old 22nd January 2011, 14:53
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,721 Times in 2,562 Posts
Default

Please run
Code:
mysql_secure_installation
to set a root password and then log into MySQL 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
  #3  
Old 22nd January 2011, 17:46
newbie14 newbie14 is offline
Member
 
Join Date: Jul 2010
Posts: 59
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Dear Falko,
Is it that I must run usr/bin/mysql_secure_installation? I have run that is have setup properly now. I would like to ask actually by defauly does centos 5.5 comes with the mysql db or we have to install it? How to upgrade it to new version? Thank you.
Reply With Quote
  #4  
Old 23rd January 2011, 14:02
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,721 Times in 2,562 Posts
Default

Quote:
Originally Posted by newbie14 View Post
Is it that I must run usr/bin/mysql_secure_installation?
It's the easiest way to set the MySQL password.

Quote:
Originally Posted by newbie14 View Post
I would like to ask actually by defauly does centos 5.5 comes with the mysql db or we have to install it?
That depends on if you selected MySQL during the initial system setup. But it doesn't make a difference if you install it later on with yum.

Quote:
Originally Posted by newbie14 View Post
How to upgrade it to new version? Thank you.
You can do this with yum:
Code:
yum install mysql mysql-server
If there's a new version, it will be installed, otherwise no change will happen.
__________________
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 26th January 2011, 20:11
newbie14 newbie14 is offline
Member
 
Join Date: Jul 2010
Posts: 59
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

Dear Falko,
Thank you for your guidance will follow it accordingly.
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
Horde Groupware Webmail Edition ByteMe Networking Tips/Tricks/Mods 17 20th December 2012 10:12
CPU load locks up box. Apache or MYSQL related. crypted General 61 29th October 2010 22:16
ISPConfig3 Mail Warn Errors reason8 General 3 25th November 2009 13:58
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 22:24.


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