mysql

Importing information_schema from an other mysql server

While investigating some mysql stuff at work I imported the whole mysql dump from our production system into my localhost installation. Among the 2000 or so databases was also information_schema, and I ended up with problems like :

root@pluto:~# /etc/init.d/mysql status
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 
'debian-sys-maint'@'localhost' (using password: YES)'
 * 

The solution was to reset password fr debian-sys-maint user in mysql.

GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' 
IDENTIFIED BY 'password' WITH GRANT OPTION;

Where ‘password’ is found in /etc/mysql/debian.cnf 🙂

I got this one from ubuntuforums.org.