Check the below URL :
http://admin.webhostingdevelopment.com/viewtopic.php?f=108&t=115&p=130#p130
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) + cpanel jailed shell
04
November
2012
Getting the error “ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)” while I try to connect to mysql via a jailed shell enabled user.
[email protected] [~]# mysql
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
[email protected] [~]#
Solution :
http://admin.webhostingdevelopment.com/viewtopic.php?f=84&t=74
You need to specify the hostname so you can connect.
mysql -h=127.0.0.1 -u user_name -p
or
mysql -h=localhost -u user_name -p
Account Creation Status: failed (Sorry, a mysql user with the name + already exists
ARUN Posted in MYSQL, WHM BACKEND, WHM FRONTEND，
19
October
2012
This mainly happens if you terminated a cpanel account and somehow the MySQL user was not deleted properly.
Solution : Try deleting the mentioned user.
Delete the user :
mysql
mysql > use mysql;
mysql > drop user testusr7@localhost;
OR
mysql> delete from mysql.user where user=’testusr7′;
You can aslo check this using :
select User, Host from user where User like ‘%testusr7%’;
Now try restoring/recreating whatever you were trying to do and see if you still receive the error.
If yes do
grep testusr7 /var/cpanel/databases/users.db
grep testusr7 /etc/dbowners
If the user exist in the above files, delete that and try again.
OR
create a cpanel user with name “testusr7777″.
Modify account and rename that to “testusr7″
Terminate the account from WHM
It fixed for me!!!
How to reset mysql user password in linux through command prompt
ARUN Posted in MYSQL，
02
February
2012
Login to mysql.
mysql -u root -p
In mysql prompt use
mysql> use mysql;
Now change the password for user “arun” to “secret123″ as below :
[ mysql> update user set password=PASSWORD("secret123") where User='arun'; ]
How to install and configure phpmyadmin for remote database access
ARUN Posted in MYSQL，
06
September
2011
Download and install the phpmyadmin as :
cd /usr/local/apache/htdocs
wget http://iweb.dl.sourceforge.net/project/phpmyadmin/phpMyAdmin/3.4.4/phpMyAdmin-3.4.4-english.tar.gz
tar -xzvf phpMyAdmin-3.4.4-english.tar.gz
chown nobody:nobody phpMyAdmin-3.4.4-english -R
cd phpMyAdmin-3.4.4-english
In browser open Ip/phpMyAdmin-3.4.4-english/setup
Give the required fields in the first page. Save and quit.
How to reset mysql root password in linux centos
ARUN Posted in MYSQL，
29
July
2011
/etc/init.d/mysqld stop
[ mysqld_safe --skip-grant-tables & ]
mysql -u root
use mysql;
update user set password=PASSWORD(“YOUR_ROOT_PW”) where User=’root’;
Above command can be used to reset plesk admin password as well.
flush privileges;
quit
/etc/init.d/mysqld stop
/etc/init.d/mysqld start
mysql -u root -p
Mysql database wont show up in cpanel after a migration.
ARUN Posted in MYSQL，
21
February
2011
Solution that worked for me :
UPDATED perl
/scripts/checkperlmodules –force
UPCP to stable version…(Didnt fix)
Ran upcp in release version. (FIXED here)
Changed to stable and ran upcp and everything worked fine for me.
Also check the /var/lib/mysql to make sure all dbs have correct naming e.g. there is no folder there like someuser_somedb.bak
Mysql tuner
ARUN Posted in MYSQL，
14
February
2011
cd /usr/local/src/
wget mysqltuner.pl
perl mysqltuner.pl
Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) [2002]
ARUN Posted in MYSQL，
19
January
2011
Getting the following error on mysql sites and also when trying to access mysql from server
============
Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) [2002]
============
Solution :
vi /etc/my.cnf
skip-innodb
Try to restart mysql and if it dont start then use killall -9 mysqld
After that restart mysql
Forcing InnoDB Recovery
ARUN Posted in MYSQL，
06
January
2011
In my.cnf add
[mysqld]
innodb_force_recovery = 4
How to clear the brute force database
28
December
2010
When you are blocked by brute force try the below command to clear the database.
SSH to server
mysql -u user -p
mysql> connect cphulkd;
mysql> select IP, BRUTETIME from brutes order by BRUTETIME;
mysql> delete from brutes;
phpmyadmin upload limitation
ARUN Posted in CPANEL FRONTEND, MYSQL, WHM BACKEND, WHM FRONTEND，
21
December
2010
To increase the phpmyadmin upload limitation in cpanel servers you can edit the php.ini file mentioned below :
vi /usr/local/cpanel/3rdparty/etc/phpmyadmin/php.ini.
upload_max_filesize = 100M
post_max_size = 100M
Even if you edit the main php.ini file it wont work in this case.
Cpanel >> phpmyadmin may not reflect the change, if so go to
WHM >> tweak settings >> cPanel PHP max POST size >> and increase the limit.
or
Increase WHM >> Tweak Settings >> cPanel PHP max upload size
The MySQL® server is currently offline.
ARUN Posted in MYSQL, WHM BACKEND, WHM FRONTEND，
03
December
2010
Getting error “The MySQL® server is currently offline.” while trying to add database.
Solution :
WHM >> Reset Local MySQL Root Password
