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

Arunlal Ashok

Linux Server Administrator. I'm dealing with Linux servers since 2012. I started this blog to share and discuss my ideas with the world. Check My Profile!! in uPwork (oDesk) and let me know if you need any assistance. Thanks!!

You may also like...

Leave a Reply

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