MySQL

Today my friends at bluefur.com made an upgrade in their server, and suddenly go2linux.org went off-line :(

The problem reported was:

"Client does not support authentication protocol", so after working with Tina from the technical support at ,Bluefur the problem was solved by re-adding the MySQL user.

You may find more info about this with this link:

http://dev.mysql.com/doc/refman/5.0/en/old-client.html

Sorry for the inconvenience to those who have found the site down.

Today I ran into a problem with my blog, for some reason after a two hours server failure (sorry for that) one of my database's table appeared corrupted.

It was the sessions table and therefore I was no able to login to my drupal again, that was really bad, after one hour of being nervous, I started to figure out what was wrong.

Once I realized that table was corrupted I went to PHPmyadmin and selected my MySQL database.

If you ever loose your mysql root password (remember is not the same as the system root password) you can recover it following this steps

Start MySQL in safe mode

mysqld_safe --skip-grant-tables

Enter the console as root

mysql -u root

Set the new password

UPDATE mysql.user SET Password=PASSWORD('new_password') WHERE User='root';

Update the privileges

FLUSH PRIVILEGES;

When you first install MySQL you need to set a password for root to be sure nobody is going to access your Databases.

If your MySQL is a fresh installation you will need this command

mysqladmin -u root password newpassword

This is used when there is no previous password, if what you need is to change a password already set, you will need this other command.

mysqladmin -u root -p oldpassword newpassword

And finally if you want to change some other's password (not root) use this command

mysqladmin -u someuser -p oldpassword newpass

Yesterday, Google announced that they were going to release it's own changes to MySQL, which the change to fit their needs, this is good as the developers could get some of this changes to include on the official release, or the general public can use some of these changes for their own purposes.

As I was trying to find an easy way to backup a MySQL database with no ssh access to the server, there should be better ways, but i found this easy one.

You will need a Shell script, a .php script.

Ok, lets make this work

MySQL is one of the most used Databases in Linux, (if not the most).

It is a great Database engine, but anyway it could have problems, or your server, if it goes out of power for instance, you could loose a lot of data, so backing up is always a good idea.

A good command for doing this is mysqldump, this is a Linux shell mysql command, so you may need ssh access to the server to run it. (Later I will publish a php version of this)

What mysqldump really does is to create a script with the structure and the data to create and populate a "restored" Database with the data of the "backed up" Database

So let's go to the How To.

Hi, I want to share this with all of you, today my server suddenly start showing this.