Category Archives: MySQL

Recommended MySQL

How to Backup Multiple MySQL Databases Automatically! [SCRIPT]

Tired of making MYSQL database backups one by one? If you are migrating to another server or want to do a monthly MYSQL database backup of all databases in your server, you can do so by using a script that will backup all of your databases at once.

Of course, you will want to save each database separately in case you just want to restore one at a time plus it will be easier when restoring.

Here’s a script you can use, replace password with your root password.

#!/bin/bash # webserverhacks.com USER="root" PASSWORD="password" OUTPUTDIR="." MYSQLDUMP="/usr/bin/mysqldu

Click Here to Read Full Article

Leave a comment

How to Allow MySQL Access to Certain IP/Servers!

For those of you who run separate MySQL servers, you can easily block unwanted visitors and give access to your other web servers simply replacing “localhost” with your subnet such as “192.168.1.%”, where the % will be a wild card to allow any servers in the 192.168.1.xxx to connect.

This can easily be changed via phpMyAdmin.

Click Here to Read Full Article

Leave a comment

Really Great Article on MySQL and Web Server!

Check out this great article by a MySQL expert who goes into detail how MySQL and web servers work and take on the load on servers. – link

Click Here to Read Full Article

Leave a comment

How to Reset WordPress Password via MySQL Command Line!

For those of you wondering how to reset your WordPress admin password via MySQL command line, here’s how to do it:

Enter your MySQL command line with something like:

mysql -uroot -p

Then enter your password.

Once inside the MySQL command line do:

show databases;

and then find your database for the WordPress blog that you want to change password.

use mydatabase;

where mydatabase should be “your” database.

Then do:

update wp_users set user_pass =MD5(’typenewpasswordhere’) where id=1;

Click Here to Read Full Article

Leave a comment

Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!

For those of you having trouble starting your MySQL server, try this to log your errors:

mysqld_safe --log-error=/var/log/mysql.err

Then do:

cat /var/log/mysql.err

to read what went wrong.

Click Here to Read Full Article

Leave a comment