Skip to main content

Mysql Commands Cheat sheet for Linux plesk users

Mysql Commands

mysql -uadmin -p`cat /etc/psa/.psa.shadow` DATABASE_NAME == Access MySQL databases in Plesk

mysql -uadmin -p`cat /etc/psa/.psa.shadow` === root password for MySQL ==> Root is admin user in plesk

dbclient --direct-sql --sql="select * from misc" == windows plesk + mysql == dbclient utility for checking mysql db in plesk

Reset the Plesk MySQL Password

1. /etc/init.d/mysqld stop

2. /usr/bin/ ?ls /usr/bin |grep mysql |grep safe? ?skip-grant-tables & (If the above command returns ?No such file or directory,?)

/usr/bin/safe_mysqld ?skip-grant-tables & (If the above command returns ?No such file or directory,?)

/usr/bin/mysqld_safe ?skip-grant-tables &

3. /etc/init.d/mysqld start

4. mysql;

5. use mysql;

6. update user set Password=password(?PLESK_PASSWORD?) where User=?admin?;

7. flush privileges;

8. quit

9. /etc/init.d/mysqld restart


mysqldump -u admin -p `cat /etc/password/.psa.shadow` database_name > database_name.sql Back Up MySQL Databases From The Command Line

mysqldump -u admin -p `cat /etc/password/.psa.shadow` --databases database_one database_two > two_databases.sql Multiple databases can be backed up at the same time

mysqldump -u admin -p `cat /etc/password/.psa.shadow` --all-databases > all_databases.sql Back up all of the databases on a server:

mysql -u admin -p `cat /etc/password/.psa.shadow` database_name < database_name.sql Restore a single database.

mysql -u admin -p `cat /etc/password/.psa.shadow` database_name < all_databases.sql Restore a single database from dump of all the databases

check and repair MySQL database tables

mysql -u admin -p `cat /etc/password/.psa.shadow` check table tablename;

mysql -u admin -p `cat /etc/password/.psa.shadow` repair table tablename;

GRANT privileges in MySQL

GRANT SELECT ON database.* TO user@'localhost'; If the database user already exists.

GRANT SELECT ON database.* TO user@'localhost' IDENTIFIED BY 'password'; OR // GRANT SELECT, INSERT, DELETE ON database TO username@'localhost' IDENTIFIED BY 'password'; // to create a brand new user


Configuring Linux Plesk to drop external MySQL connections

# this command makes sure everything on localhost works
iptables -A INPUT -p all -s localhost -d localhost -j ACCEPT
# block all external connection attempts to MySQL
iptables -A INPUT -p tcp ?destination-port 3306 -j REJECT
/etc/init.d/iptables save
/etc/init.d/iptables restart

#check the new definitions
iptables ?list

Chain INPUT (policy ACCEPT)
target prot opt source destination
ACCEPT all ? localhost.localdomain localhost.localdomain
REJECT tcp ? anywhere anywhere tcp dpt:mysql reject-with icmp-port-unreachable

Chain FORWARD (policy ACCEPT)
target prot opt source destination

Chain OUTPUT (policy ACCEPT)
target prot opt source destination



Popular posts from this blog

Qmail cheat sheet

1) To check the mail queue in plesk from command line, you can use the command :


2) You can examine the queue with qmail-qread.


3) From the qread command you get the message id . In the above example , let us assume one of the id is 524514 . Now you can find the file holding the email in/var/qmail/queue with find command.

# find /var/qmail/queue -iname 524514


/var/qmail/queue/mess/22/524514 (mail headers)


4) From the mail header you get the IP address

vi /var/qmail/queue/mess/22/524514


Shortcut for the cool guys

find /var/qmail/queue -iname queu_id | grep mess | xargs less


4) If you wish …

Logical volume vmxxxx_img is used by another device - Error on LVM removal

Hi Folks,

I've faced error while trying to remove an LVM from the server.

The exact LVM error will be "Logical volume vmxxxx_img is used by another device" on executing the lvremove command.

Feel free to remove the following steps to remove the LVM from the server.

Note: Please remember to replace <id> with your VMID in the below section.

dmsetup ls dmsetup info -c xen-vm<id>_img dmsetup remove xen-vm<id>_img lvremove -f /dev/xen/vm<id>_img ----------------------------------------------------------

Cheat sheet for Hardware RAID health check - Megaraid, Adaptec, 3wareraid and HPraid.

Hi Folks,

In another post "raid type" I've mentioned how to find if the server is running with Software or Hardware RAID.

Here, we can go ahead and check the health of the Hardware RAID array in the server.

The first thing we need to detect is the controller in which the raid is configured and you can easily get it from the another post that I mentioned earlier. However, I'm providing it here again for your convenience.

1. Login to the server as the root user.
2. Execute the following command.

/sbin/lspci -vv | grep -i raid

3. This will show the raid controller running on the server. The different types of controller I've worked with includes

a. Megaraid which uses megacli
b. Adaptec which uses arcconf.
c. 3ware raid which uses tw_cli
d. HPraid which uses hpacucli.

How to check the Megaraid array health status?

The Megaraid is usually installed in the /opt/MegaRAID and you can execute the following command to verify the health of the array.