Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Server Operation

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 13th January 2010, 01:54
BorderAmigos BorderAmigos is offline
Senior Member
 
Join Date: Apr 2008
Location: San Diego & Tijuana
Posts: 302
Thanks: 26
Thanked 33 Times in 31 Posts
Send a message via MSN to BorderAmigos Send a message via Yahoo to BorderAmigos
Default MySQL doesn't see databases

I was trying to install Hoard webmail. I ran it's mysqlcreate.sql script and got hosed. Now MySQL doesn't see any databases except information_schema. Looking in the /var/lib/mysql/ directories it appears all the data is still there.

phpmyadmin says I have No Privileges when logged in as root!?!?!

Anyone know how to get it back? Thanks.
__________________
System6Hosting.com, ISPConfig 3, Debian.

Last edited by BorderAmigos; 13th January 2010 at 01:57.
Reply With Quote
Sponsored Links
  #2  
Old 13th January 2010, 03:07
BorderAmigos BorderAmigos is offline
Senior Member
 
Join Date: Apr 2008
Location: San Diego & Tijuana
Posts: 302
Thanks: 26
Thanked 33 Times in 31 Posts
Send a message via MSN to BorderAmigos Send a message via Yahoo to BorderAmigos
 
Default

Found a solution elsewhere. In case this happens to anyone else...

http://www.webmasterworld.com/databa...ql/3150519.htm

Code:
My init file (/root/mysql-init) read like:
======================================
GRANT ALL privileges ON *.* TO 'root'@'localhost' IDENTIFIED BY 'shinynewpasswd';
=====================================

My commands in shell:

======================================
shell> kill `cat /var/run/mysqld/mysqld.pid`
shell> mysqld_safe --skip-kill-mysqld --init-file=/root/mysql-init &
======================================


======================================
# mysql -u root -pshinynewpasswd
Welcome to the mysql monitor. Commands end with ; or \g.
Your mysql connection id is 8 to server version: 4.1.20

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('shinynewpasswd');
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye
======================================
__________________
System6Hosting.com, ISPConfig 3, Debian.
Reply With Quote
The Following User Says Thank You to BorderAmigos For This Useful Post:
falko (13th January 2010)
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
ISPConfig3 Mail Warn Errors reason8 General 3 25th November 2009 14:58
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 10:11
cannot assign MySQL databases tom Installation/Configuration 2 29th March 2007 13:46
Recovering unlinked mysql databases and users... Dave Lane Installation/Configuration 2 10th May 2006 20:45
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 17:04


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


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