Tag Archives: MySQL HowTo’s

How to store encrypted passwords in MySQL

Mysql storing encrypted passwords howto, All these commands were tested on MySQL5 This example we will create a MD5 encrypted password We need to create a table called user_md5, (The value is returned as a binary string of 32 hex … Continue reading

Tagged , | Leave a comment

How to add users and their permissions in MySQL

Mysql user howto, All these commands were tested on MySQL5 How to add a user. I am using the user test as a example as well as the host localhost as an example… "CREATE USER ‘test’@’localhost’ IDENTIFIED BY ‘passwd’;" How … Continue reading

Tagged , | Leave a comment

How to create a database in MySQL

How to create a database? By default mysql installs as the root user with no passwd (unless noted otherwise) Verify that mysql is running by one way (out of many ways). This is the command…. "ps -fe |grep mysqld |grep … Continue reading

Tagged , | Leave a comment

How to restore a MySQL Database

Now that you know how to backup your database,I will show you how to restore it on another database. The most common and basic way to restore, is a restore of a database. mysql -u test1 –password=pass1 world < world.sql … Continue reading

Tagged , | Leave a comment

How to Back up a MySQL database

If you’ve got a website with a database or a custom database running for your applications, it is imperative that you make regular backups of the database… Following examples are using mysqldump You can use mysqldump to create a simple … Continue reading

Tagged , | Leave a comment