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 […]
Category: Database
MySQL date range, case study
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 […]
Export picture from mysql database to file
[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) […]
Get table diff with sqlyog
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 […]
ERROR 2003: Can’t connect to MySQL server
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 172.88.1.5 Enter password: ERROR 2003: Can’t connect to MySQL server on ‘172.88.1.5’ (61) according to this, that means no tcp/ip […]