Impossible to create database’s user::MySQL governor

At last I figured out the problem with MySQL DB user creation that I got!!!
Here is the error details:

When I tried to create a new database user through cPanel I got the following error!

The adminbin “hooks” in the “Cpanel” namespace call to function “mysql::adduser” ended prematurely: The subprocess reported the “” (255) error when it ended.

For this I had to search a lot with MySQL permissions and other in the server. Here I’m listing what all were I found from the internet 😀

Please check the following for troubleshooting this problem with MySQL user creation:

>> You have to check the permission/owner of MySQL folder in your server.
>> You need to check the following entry in “/usr/share/lve/dbgovernor/utils/dbgovernor_map”

Change this line
#!/usr/bin/perl
With this line.
#!/usr/local/cpanel/3rdparty/bin/perl

Still getting the same error,

>> You need to check the simlink of sock file on /tmp directory.

/var/lib/mysql/mysql.sock to /tmp/mysql.sock

At last I fixed the problem bye executing the following command 😀

yum update governor-mysql --enablerepo=cloudlinux-updates-testing

That’s it!! Just go to the cPanel and create the database user 😀

Related:

1. Performance tuning script for MySQL – Command-line Mysql Tuner
2. Simple PHP script to check the MySQL database connection from web-browser
3. How to change MySQL root password from Kloxo Panel
4. How to know the MySQL uptime from commandline – 3 Methods

Post navigation

Arunlal Ashok

Operations Engineer at Endurance International Group. Linux lover. Like to play on Linux console. I started this blog to share and discuss Linux thoughts.

Always happy for an open discussion! Write to arun (@) crybit (dot) com. Check about me for more details. About this blog and our strong members, check The team CryBit.com
We like to travel. Our travelogues are published at Trip Mentor

Leave a Reply

Your email address will not be published. Required fields are marked *