Hi, I am using SuSE 7.0 and MySQL 4.0.1. I had quite a time getting the daemon started on Linux but finally succeeded. I can start the daemon logged on as su and I can connect to the database as user=mysql and modify the existing DB called test.
I set the permissions as recommended in INSTALL-BINARY. Logged on as "su" I did the following: chown -R root /usr/local/mysql chown -R mysql /usr/local/mysql/data chgrp -R /usr/local/mysql chown -R /usr/root/local/mysql/bin Apparently what should happen is the system administrator should be able to start and stop the daemon and control the binary files and anybody in the group that I created "mysql" should be able to manipulate data in the DBs to which they have permissions. Well.. I have a problem when I try to issue the command to create a new database. mysqladmin create <databasename> If I am logged on as root or a user in the group mysql, I get the message Access denied for <anybody>@localhost. I tried doing a chmod on several files in mysql but to no avail. Also I notice there is no file in etc called my.cfg as the documentation suggests. It seems that the permissions are stored in a table in /usr/local/mysql/data/mysql but I cannot get at the table to change anything. It would seem that there is someway to issue some kind of external command that would change the permissions for the superuser and user mysql without manipulating that table directly. I am really not concerned about security right now. This is a stand alone Linux server at my house that is rarely connected to anything. I just want to practice my SQL skills. Any ideas. ********************************************************************** Cindy Nelson (404) 213-9498 cell 202 Jimmie Nelson Rd SW (770) 382-4474 home Kingston, Ga 30145 e-mail: [EMAIL PROTECTED] http://home.earthlink.net/~cindynelson ********************************************************************** --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php