On Jan 22, 2008 2:02 PM, <[EMAIL PROTECTED]> wrote: > I may have spoken too soon. Re-installing mysql got me to where I can > login to the console but the suggested commands still fail: > > # mysql -uroot -p > Enter password: > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 16 > Server version: 5.0.44-log Gentoo Linux mysql-5.0.44-r2 > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> create database bookmarks; > ERROR 1006 (HY000): Can't create database 'bookmarks' (errno: 2) <snip>
Hmm - odd. What does the output of: ls -al /var/lib/mysql give you? Also, what do you get in the MySQL console if you do a: show databases; Also, try doing the create database procedure as previously outlined, then do a tail -n100 /var/log/mysql/mysql.err and /var/log/mysql/mysqld.err and /var/log/mysql/mysql.log - anything relative showing up in there? Maybe post the output of the above commands, as well as (tbz2'd, if they're large) attaching the /var/log/mysql/* files - might help us track this down... -James -- gentoo-user@lists.gentoo.org mailing list
