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.

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>