Category Archives: Uncategorized

MySQL force user change password

Since version 5.6.6 MySQL has introduced the capability to force an user to change their password. You can archive that by issue ALTER USER PASSWORD EXPIRE statement. ALTER USER 'marcelo'@'localhost' PASSWORD EXPIRE; Next time marcelo tries to login from localhost … Continue reading


Liked? Help and Share!
Posted in Uncategorized | Leave a comment

How to rename table in MYSQL

To rename a table in MySQL you just need to run a command named RENAME TABLE, the syntax is very easy to use, RENAME TABLE tb1 TO tb2; The RENAME TABLE command will rename the table atomically, which means your … Continue reading


Liked? Help and Share!
Posted in Uncategorized | 4 Comments

MySQL IN AND OR

MySQL IN??? MySQL OR??? MySQL AND??? When I use one and when I use other? we will use the city table to this tutorial: +————-+———-+——+—–+———+—————-+ | Field | Type | Null | Key | Default | Extra | +————-+———-+——+—–+———+—————-+ | … Continue reading


Liked? Help and Share!
Posted in Uncategorized | 2 Comments

Recording session on MySQL

Hi guys, today let’s learn about a very useful option on mysql command line to recording all what happen in your mysql session, It’s the option –tee. Is very easy to use, you just need to add the –tee=/path/to/file mysql … Continue reading


Liked? Help and Share!
Posted in Uncategorized | Leave a comment

How to rename a database in MySQL?

Today we will talk how do you can easily rename a database in MySQL. At the MySQL version 5.1.7 was added a command to do this job named RENAME DATABASE RENAME {DATABASE | SCHEMA} db_name TO new_db_name; But it was … Continue reading


Liked? Help and Share!
Posted in MySQL, mysqldump, Uncategorized | 7 Comments