DE

↑ ↓ select, Enter open, Esc close

Open the MySQL console as Plesk admin

harmless rootMySQL and MariaDBdebian, ubuntu
root@server
plesk db

Starts the MySQL client as the user admin, the administrative database account of Plesk, and preselects the Plesk database psa. Any other database can be selected with USE. The command itself changes nothing, but statements run in the console can change anything.

Note: Plesk servers usually have no usable MySQL root password. admin is the account with full privileges.

Also searched as

  • mysql root password plesk
  • log in to mysql as admin plesk
  • plesk database console

Related one-liners

All in MySQL and MariaDB

Use the Plesk MySQL admin in scripts and one-liners

#MYSQL_PWD=$(cat /etc/psa/.psa.shadow) mysql -u admin -e 'SHOW DATABASES;'
cautionMySQL and MariaDB

Analyze the slow query log for the slowest queries

#mysqldumpslow -s t -t 10 /var/log/mysql/mariadb-slow.log
harmlessMySQL and MariaDB

Back up a single database consistently as gzip

$mysqldump --single-transaction --quick -u dbuser -p wp_example | gzip > /var/www/vhosts/example.com/wp_example.sql.gz
harmlessMySQL and MariaDB

Back up all databases into one gzipped file

#mysqldump --single-transaction --quick --all-databases --routines --events | gzip > /root/all-databases.sql.gz
harmlessMySQL and MariaDB

Back up each database into its own gzipped file

#for db in $(mysql -NBe 'SHOW DATABASES' | grep -Ev '^(information_schema|performance_schema|sys)$'); do mysqldump --single-transaction --quick "$db" | gzip > "/root/db-backup/$db.sql.gz"; done
harmlessMySQL and MariaDB

Check all MySQL tables for errors

#mysqlcheck --all-databases --check --silent
harmlessMySQL and MariaDB

Read first, then run.

The commands on myline.de act directly on servers, files and databases. A wrong path or placeholder can delete data irreversibly or make a server unreachable.

  • All commands are provided without warranty and are not tested on every system.
  • Understand what a command does before running it, and check every placeholder.
  • Make a backup first and, if possible, try it on a test system.
  • You run commands at your own risk. Liability for damages is excluded to the extent permitted by law.