Ha! Nice one Nick. Changed the user to mysql, but there's no mysql group, so changed the group to daemon (sounded right). Anyway mysql is now up and running.
Just out of interest, the owner of all the directories in /usr/local/mysql is '503'. Grepping /etc/passwd for '503' returns nothing. mysql is user 60. 503 would be the next sequential user on the system though. Did I ought to change them all to mysql:daemon? Also, does anyone know where I put the command to start mysql at startup on a SuSE 8.1 box? Cheers, and thanks Peter On Wed, 2003-07-30 at 19:09, Nick Stuart wrote: > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
