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 managing Linux servers since 2012. I started this blog to share and discuss my ideas. 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 *