landon kelsey wrote:
(1) performed a standard install of Redhat Linux 9 months ago...now
(I found mysql 3.23.52 installed)
Under root, I executed mysql_install_db successfully:
showing:
installing all prepared tables
031219 0:44:16 /usr/libexec/mysqld: Shutdown Complete
Why, it was already installed.
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: /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h landon password 'new-password' See the manual for more instructions.
NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run the /usr/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 /usr ; /usr/bin/safe_mysqld &
You can test the MySQL daemon with the benchmarks in the 'sql-bench'
directory:
cd sql-bench ; run-all-tests
Please report any problems with the /usr/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
(2) safe_mysqld & produces
landon (root) /usr/bin [311]>safe_mysqld &
[1] 3247
landon (root) /usr/bin [312]>Starting mysqld daemon with databases from
/var/lib/mysql
031219 00:25:56 mysqld ended
[1]+ Done safe_mysqld
It is probably already running.
(3) cat /var/lib/mysql/xxx.log produces:
/usr/libexec/mysqld, Version: 3.23.52-log, started with: Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock Time Id Command Argument
(4) here is what mysql.sock looks like
landon (root) /usr/bin [303]>lsa /var/lib/mysql
total 20
drwxr-xr-x 4 mysql mysql 4096 Dec 18 23:42 ./
drwxr-xr-x 29 root root 4096 Jul 8 18:31 ../
drwx------ 2 root root 4096 Dec 18 21:21 mysql/
srwxrwxrwx 1 mysql mysql 0 Dec 18 23:42 mysql.sock=
drwx------ 2 root root 4096 Dec 18 21:21 test/
-rw-rw---- 1 mysql mysql 156 Dec 18 22:52 xxx.log
That means it is already running. Have you tried to run the client 'mysql' ?
(5) also tried ./bin/safe_mysqld --user=mysql & same result
(6) tried safe_mysqld --debug & couldn't find the mysqld.trace file
(7) safe_mysqld is in /usr/bin ... /usr/bin is in the PATH
_________________________________________________________________
Get dial-up Internet access now with our best offer: 6 months @$9.95/month! http://join.msn.com/?page=dept/dialup
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
