store | blogs | forums | twitter | facebook | wiki | mailing lists | downloads | support portal
Atomic Secure Linux
It is currently Mon Apr 21, 2014 12:48 pm

» Feed - Atomicorp

All times are UTC - 5 hours [ DST ]




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Plesk / MySQL Create User Broken
Unread postPosted: Sun May 22, 2011 3:14 pm 
Offline
Forum User
Forum User

Joined: Fri Feb 25, 2011 6:00 pm
Posts: 22
Location: 222
Hello again....

I'm pretty sure this error a result of this post: http://www.atomicorp.com/forums/viewtopic.php?f=3&t=5019

I now have a larger issue that I think may have stemmed from updating php and fastcgi... I have no clue how it could be related. BUT once again my host says it's my problem and would not even submit a plesk ticket because it needs to be diagnosed first, which they will not do?

Anyway. I get this error message when trying to add a database and user in plesk to any domain on the server:
Code:
Error: Connection to the database server has failed:
Table 'mysql.servers' doesn't exist


I really hope there is an easy fix. I need to create several databases this week and will be in a very bad spot if I can't get this fixed. So please help if you can. Thank-you.


Top
 Profile  
 
 Post subject: Re: Plesk / MySQL Create User Broken
Unread postPosted: Sun May 22, 2011 3:53 pm 
Offline
Forum User
Forum User

Joined: Fri Feb 25, 2011 6:00 pm
Posts: 22
Location: 222
Fix has been found! Thanks for being here! - may want to move this thread - i just realized it is out of scope of ASL.

http://crimm.me/2010/06/mysql-error-with-plesk-after-updates-on-vps-server.html

Quote:
I’m sure it has something to do with me upgrading mysql in my last post. It was an easy fix and here it is:

Google brought me to: http://forums.mysql.com/read.php?11,142 ... msg-188705

Step 1: SSH to your server
Step 2: Open mysql by typing:

mysql -u YOURUSERNAMEHERE -p

Make sure to put in your own username. When you hit enter, you’ll be asked for your mysql password.

Step 3: Use the mysql database:

USE mysql;

Step 4: Place this code in to create the table:

CREATE TABLE `servers` (
`Server_name` char(64) NOT NULL,
`Host` char(64) NOT NULL,
`Db` char(64) NOT NULL,
`Username` char(64) NOT NULL,
`Password` char(64) NOT NULL,
`Port` int(4) DEFAULT NULL,
`Socket` char(64) DEFAULT NULL,
`Wrapper` char(64) NOT NULL,
`Owner` char(64) NOT NULL,
PRIMARY KEY (`Server_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
COMMENT='MySQL Foreign Servers table';

I hope that helps someone out there!


Top
 Profile  
 
 Post subject: Re: Plesk / MySQL Create User Broken
Unread postPosted: Sun May 22, 2011 5:18 pm 
Offline
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin

Joined: Wed Dec 31, 1969 8:00 pm
Posts: 7779
Location: earth
Covered in the wiki here: http://www.atomicorp.com/wiki/index.php/Mysql


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

» Feed - Atomicorp

All times are UTC - 5 hours [ DST ]


Who is online

Users browsing this forum: Google [Bot] and 1 guest


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 post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group