Hi guys/gals, the problem is directory perms but not in the tmp. And yes you should have my.cnf in your /etc (can change this location but cant remember where), and there are sample cnf files in the support-files directory of mysql. As far as the directory issue goes simply run: chown -R mysql data chgrp -R mysql data in the mysql directory. Obviously you need to have a mysql user, and this lets that user, and only that user write to the data directory, or even enter it for that matter (besides root of course).
HTH! -Nick On Wed, 2003-07-30 at 01:19, Peter Bradley wrote: > Hi Sanya > > Don't appear to have a file called my.cnf anywhere on my system. Should > I have? If so how should it be formatted, and what should be in it? > > > Peter > > On Wed, 2003-07-30 at 18:42, Sanya Shaik wrote: > > You need to set the sock in usr/local/mysql/data/my.cnf to /tmp/mysql.sock > > > > > > > > Peter Bradley <[EMAIL PROTECTED]> wrote: > > Hi guys and gals, > > > > I'm a complete newbie to mysql, so please bear with me. > > > > Today I downloaded mysql4.0 binary distribution and installed it on my > > SuSE Linux 8.1 box. I've unzipped it and put it in: > > > > /usr/local/mysql-standard-4.0.14-pc-linux-i686 > > > > and I've created a symbolic link to give me /usr/local/mysql > > > > I then ran scripts/mysql_install_db (as root). The output was: > > > > ===================================================================== > > | > > |linux:/usr/local/mysql # ./scripts/mysql_install_db > > |Installing all prepared tables > > |030730 4:24:13 ./bin/mysqld: Shutdown Complete > > | > > | > > |To start mysqld at boot time you have to copy > > |support-files/mysql.server > > |to the right place for your system > > | > > |PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! > > |This is done with: > > |./bin/mysqladmin -u root password 'new-password' > > |./bin/mysqladmin -u root -h linux password 'new-password' > > |See the manual for more instructions. > > | > > |NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run > > |the ./bin/mysql_fix_privilege_tables. Otherwise you will not be > > |able to use the new GRANT command! > > | > > |You can start the MySQL daemon with: > > |cd . ; ./bin/mysqld_safe & > > | > > |You can test the MySQL daemon with the benchmarks in the 'sql-bench' > > |directory: > > |cd sql-bench ; perl run-all-tests > > | > > |Please report any problems with the ./bin/mysqlbug script! > > | > > |The latest information about MySQL is available on the web at > > |http://www.mysql.com > > |Support MySQL by buying support/licenses at https://order.mysql.com > > | > > |linux:/usr/local/mysql # > > | > > =================================================================== > > > > I then tried to start mysql as a normal user and got: > > > > ==================================================================== > > | > > |[EMAIL PROTECTED]:/usr/local/mysql> bin/safe_mysqld --log & > > |[1] 2693 > > |[EMAIL PROTECTED]:/usr/local/mysql> Starting mysqld daemon with databases > > |from /usr/local/mysql/data > > |bin/safe_mysqld: line 296: /usr/local/mysql/data/linux.err: Permission > > |denied > > |rm: cannot remove `/tmp/mysql.sock': Operation not permitted > > |bin/safe_mysqld: line 1: /usr/local/mysql/data/linux.err: Permission > > |denied > > |tee: /usr/local/mysql/data/linux.err: Permission denied > > |030730 04:27:40 mysqld ended > > |tee: /usr/local/mysql/data/linux.err: Permission denied > > | > > |================================================================== > > > > So I tried as root and got: > > > > ==================================================================== > > | > > |linux:/usr/local/mysql # ./bin/safe_mysqld --log & > > |[1] 2740 > > |linux:/usr/local/mysql # Starting mysqld daemon with databases from > > |/usr/local/mysql/data > > |030730 04:30:05 mysqld ended > > | > > ==================================================================== > > > > I did check to see if mysqld was running, but of course it wasn't. I > > also tried the perl script run-all-tests, but it just reported mysql > > wasn't running ('Can't connect to local MySQL server through socket > > '/var/lib/mysql/mysql.sock' (2)' when connecting to > > DBI:mysql:database=test;host=test;host=localhost with user: '' password: > > '') > > > > Can anyone help? > > > > Thanks > > > > Peter > > > > > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > --------------------------------- > > Do you Yahoo!? > > The New Yahoo! Search - Faster. Easier. Bingo. > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]