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 […]

Just stumble upon situation where I need to find out if specific date in a date range. I’ve try using lower than with greater than operator and use between in second attempt. Quick mysql shell mode 🙂 Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\Documents and Settings\alam>cd c:\appserv\mysql\bin   C:\AppServ\mysql\bin>mysql -uroot -p […]

[amazonify]032152599X:left[/amazonify] As our data getting mobile and copying picture is annoying for me I decide to save the picture in the database (mysql). Another challenge came when other division need the data exported in a directory with same dimension (135 x 180 pixel). Structure for table ‘student_pic’  : CREATE TABLE `student_pic` (   `image_id` int(10) […]

As the job area getting bigger and bigger, new tables created and others table get normalize. It’s often to see adding field or remove some field from table. Development phase also take some place and different computer.  Need more time to get ‘whats new‘ in table structure. An illustration for example : Working to make […]

I Need to add remote user for add, select, update and delete in mysql. grant select,insert,update,delete on postfix.* to "postfix_rc"@"%" identified by "postfix_xxxxyyy" with grant option; try to access : -bash-2.05b$ mysql -upostfix_rc -p -h Enter password: ERROR 2003: Can’t connect to MySQL server on ‘’ (61) according to this, that means no tcp/ip […]