Plesk / MySQL Create User Broken

General Discussion of atomic repo and development projects.

Ask for help here with anything else not covered by other forums.
seangelica
Forum User
Forum User
Posts: 22
Joined: Fri Feb 25, 2011 6:00 pm
Location: 222

Plesk / MySQL Create User Broken

Unread post by seangelica »

Hello again....

I'm pretty sure this error a result of this post: http://www.atomicorp.com/forums/viewtop ... 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: Select all

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.
seangelica
Forum User
Forum User
Posts: 22
Joined: Fri Feb 25, 2011 6:00 pm
Location: 222

Re: Plesk / MySQL Create User Broken

Unread post by seangelica »

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-wit ... erver.html
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!
scott
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
Posts: 8355
Joined: Wed Dec 31, 1969 8:00 pm
Location: earth
Contact:

Re: Plesk / MySQL Create User Broken

Unread post by scott »

Post Reply