MySQL 10

Tutorials, tricks and tips for Linux system administration relating to  mysql, Covering various topics on how to install, configure, manage, replication and performance tuning.
 

How To Copy MySQL Grants

What Are MySQL Grants? MySQL grants are privileges issued to users in MySQL. They allow users different permissions to different databases, specific tables or even fields.  In certain situations, such as migrating to a new server, you will need to duplicate those grants from one user to another or copy all of the grants to […]

7 years ago More
 

Increasing MySQL Max Connections

You can see what the current setting is by running the following SQL command from the MySQL command line tool, phpMyAdmin, or a similar tool: show variables like "max_connections"; This will return a resultset like this, showing you what your current max connections setting is: MariaDB [(none)]> show variables like "max_connections"; +-----------------+-------+ | Variable_name | Value | […]

7 years ago More
 

Reset a WordPress Password with MySQL

This is how to reset a WordPress password through ssh/command line on a Linux server using the MySQL client. This same practice could be executed via PHPMyAdmin or another web based MySQL tool. WordPress stores the passwords in a one-way encryption hash (md5). To start this process you need to login to the server via […]

7 years ago More