Just another post for my archive
One our sandbox accidently delete root account with host ‘localhost’. We need to recover the account by grant new root account back into system.
The steps are :
1. Turn off mysql service
sandbox# /usr/local/etc/rc.d/mysql-server stop

2. Run mysql with skip grant table mode
sandbox# mysqld_safe –skip-grant-tables &
[1] 5187
sandbox# Starting mysqld daemon with [...]

Click here to read more from Database

Just for my own record, dealing with Null type field.
Checking with :
select * from tablename where field1=”  -> this one not work
select * from tablename where field1=’Null’ -> same too
is null is the answer
select * from tablename where field1 is null
Save my day, thanks to St4r

Click here to read more from Database

 
Deal with gammu and mysql make learn more about mysql feature in mysql 5.0 called trigger.
Looking around in google make me find some interesting links around trigger in mysql, here the list :

A Tutorial on Database Concepts, SQL using MySQL, basic concept including terms.
MySQL Triggers Tryout, Onlamp explain it with sample.
Creating Triggers, tips for creating [...]

Click here to read more from Database

just found error in /var/log/messages and when I try to backup postfix database.
mail# mysqldump -upostfix -p postfix > postfix.sql
Enter password:
mysqldump: Got error: 1044: Access denied for user ‘postfix’@’localhost’ to database ‘postfix’ when using LOCK TABLES
checking user privileges using information_schema
mail# mysql -upostfix -p

Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection [...]

Click here to read more from Database