On Tue, 2006-03-21 at 09:58 +0100, Dominik Klein wrote: > > [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
Thanks. This gets me going. Re proper file permissions: there seem to be mysql files all over the place. Do I have to find them all and change permissions on all of them? The MySQL manual I downloaded lists about eight different directories as including MySQL files, and I'll already seen at least one case where my installation put something in a different directory. (The rpm I installed is mysql-4.1.11-2 according to 'rpm -q mysql'.) EB > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
