HostOnNet.com Forum Index HostOnNet.com
Private Label Reseller Plan
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

phpmyadmin shows all mysql database

 
Post new topic   Reply to topic    HostOnNet.com Forum Index -> Dedicated Servers
View previous topic :: View next topic  
Author Message
Seby
FlashWebHost Member


Joined: 18 Oct 2005
Posts: 13
PostPosted: Tue Oct 18, 2005 6:06 pm    Post subject: phpmyadmin shows all mysql database Reply with quote
I loged in phpMyadmin, it listed all databse on server. Anyone know about this ?
Back to top
View user's profile Send private message
admin
Site Admin


Joined: 23 Jan 2003
Posts: 256
Location: India
PostPosted: Tue Oct 18, 2005 6:09 pm    Post subject: Reply with quote
On Cpanel server this happen at times when WHM or Cpanel is upgraded.

There are 3 ways to FIX the problem. You have to follow any one of the method given below, first one is easy.


Method 1

Quote:

/scripts/cleanupmysqlprivs



Method 2

Run following command as root in MySQL prompt

Quote:

UPDATE mysql.user SET Lock_tables_priv = 'N', Create_tmp_table_priv = 'N' WHERE
User != 'root'; FLUSH PRIVILEGES;


Method 3

run the command as root

Quote:

/usr/bin/mysql_fix_privilege_tables

_________________
HostOnNet.com - Reseller Hosting
Free Ads Forum, Promote your site
NetFreeHost.com - Free Web Hosting, phpBB Hosting
Back to top
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger
Display posts from previous:   
Post new topic   Reply to topic    HostOnNet.com Forum Index -> Dedicated Servers All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © phpBB Group. Hosted by phpBB.BizHat.com


For Support - http://forums.BizHat.com

Free Web Hosting | Free Forum Hosting | FlashWebHost.com | Image Hosting | Photo Gallery | FreeMarriage.com

Powered by PhpBBweb.com, setup your forum now!