1 |
On Jan 22, 2008 2:02 PM, <reader@×××××××.com> wrote: |
2 |
> I may have spoken too soon. Re-installing mysql got me to where I can |
3 |
> login to the console but the suggested commands still fail: |
4 |
> |
5 |
> # mysql -uroot -p |
6 |
> Enter password: |
7 |
> Welcome to the MySQL monitor. Commands end with ; or \g. |
8 |
> Your MySQL connection id is 16 |
9 |
> Server version: 5.0.44-log Gentoo Linux mysql-5.0.44-r2 |
10 |
> |
11 |
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer. |
12 |
> |
13 |
> mysql> create database bookmarks; |
14 |
> ERROR 1006 (HY000): Can't create database 'bookmarks' (errno: 2) |
15 |
<snip> |
16 |
|
17 |
Hmm - odd. What does the output of: |
18 |
ls -al /var/lib/mysql |
19 |
give you? |
20 |
|
21 |
Also, what do you get in the MySQL console if you do a: |
22 |
show databases; |
23 |
|
24 |
Also, try doing the create database procedure as previously outlined, |
25 |
then do a tail -n100 /var/log/mysql/mysql.err and |
26 |
/var/log/mysql/mysqld.err and /var/log/mysql/mysql.log - anything |
27 |
relative showing up in there? Maybe post the output of the above |
28 |
commands, as well as (tbz2'd, if they're large) attaching the |
29 |
/var/log/mysql/* files - might help us track this down... |
30 |
|
31 |
-James |
32 |
-- |
33 |
gentoo-user@l.g.o mailing list |