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]