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
