[EMAIL PROTECTED] ~]$ mysqlshow
+-----------+
| Databases |
+-----------+
| test |
+-----------+
In standard setup, there is a user without a name and password, who can
connect from localhost to database "test".
So, accessing with this user gives you a list of the databases this user
can see.
[EMAIL PROTECTED] ~]$ mysqlshow mysql
mysqlshow: Access denied for user ''@'localhost' to database 'mysql'
As "" is not allowed to use database "mysql", you get the "access
denied" message.
[EMAIL PROTECTED] ~]$ su -
Password:
[EMAIL PROTECTED] ~]# mysqlshow mysql
mysqlshow: Access denied for user 'root'@'localhost' (using password:
NO)
I suppose the root-Account for your MySQL has got a password. As you
have not given a password, you are not allowed to connect.
Try "mysqlshow -p mysql"
your second mail:
> More Confusions: When I try to follow the manual and enter
> 'bin/mysqld_safe --user=mysql &' I get this:
>
> [EMAIL PROTECTED] ~]$ cd /usr
> [EMAIL PROTECTED] usr]$ bin/mysqld_safe --user=mysql &
> [1] 10340
> [EMAIL PROTECTED] usr]$ cat: /var/run/mysqld/mysqld.pid: Permission denied
> rm: cannot remove `/var/run/mysqld/mysqld.pid': Permission denied
> Fatal error: Can't remove the pid file: /var/run/mysqld/mysqld.pid
When mysql is starting, it removes any old pid-Files. If another user
started MySQL before, this pid file belongs to that user and "eric"
cannot remove it.
> bin/mysqld_safe: line 284: /var/log/mysqld.log: Permission denied
Again here: check permissions on /var/log/mysqld.log and wether "eric"
is able to write to that file.
> mysqld start'. Isn't there a way to start mysql other than as root?
You can start mysql as any user. Just make sure you have proper file
permissions.
Regards
Dominik
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
