MySql Administration on Linux
- Linux Tips for Beginners
- Beginners guide to Reading and Finding Files in Linux
- Using Grep to Search for Text in Linux
- Understanding Linux File Permissions
- How to Archive, Compress and Extract files in Linux
- Linux Piping and Redirection
- Linux Hardlinks and Softlinks
- Basic Data Recovery in Linux
- Essential Guide to Working with Files in Linux
- Apache Administration on Linux
- MySql Administration on Linux
MySql to Listen on all ports, not just localhost
If you want remote MySql administration on the server just edit the file /etc/mysql/my.cnf, find and comment out the line bind-address = 127.0.0.1: This will allow any computer access to the mysql server, so it should be used with care.
Restart MySql on Linux
You can restart the MySql server by entering the following command:
sudo /etc/init.d/mysql restart
Reset User Password
From time to time it may be necessary to reset the password of a MySql user. Here's how to do it. You will need to log onto the server using an account with root privileges, either on the MySql Administration GUI or through an application such as phpMyAdmin.
You can reset a password by executing the following SQL statement, after updating it to match your given username and password.
- UPDATE mysql.USER SET Password=PASSWORD('MyNewPass') WHERE USER='MyUsername';
- FLUSH PRIVILEGES;
MySql Backup Database
Using the command line you can easily backup a database to a SQL file.
mysqldump -u <username> -p <password> database_name > backup-filename.sql
MySql Restore Database
Just as easily as backing up a database to a SQL file, you can restore it back to the server using this command:
mysql -u <username> -p <password> database_name < backup-filename.sql