Can the user the mysqld process run as (usually the mysql user) read/write the /var/lib/data directory without problems? Does your /etc/my.cnf file contain a datadir = /var/lib/mysql or is it pointing somewhere else? Did adding skip-innodb to your my.cnf solve anything?
On Fri, 19 Dec 2003, landon kelsey wrote: > I run safe_mysqld out of /usr with ./bin/safe_mysqld & > > /var/log/mysqld.log > > 868 031219 20:52:52 mysqld started > 869 Cannot initialize InnoDB as 'innodb_data_file_path' is not set. > 870 If you do not want to use transactional InnoDB tables, add a line > 871 skip-innodb > 872 to the [mysqld] section of init parameters in your my.cnf > 873 or my.ini. If you want to use InnoDB tables, add to the [mysqld] > 874 section, for example, > 875 innodb_data_file_path = ibdata1:10M:autoextend > 876 But to get good performance you should adjust for your hardware > 877 the InnoDB startup options listed in section 2 at > 878 http://www.innodb.com/ibman.html > 879 031219 20:52:52 /usr/libexec/mysqld: Can't find file: > './mysql/host.frm' (errno: 13) > 880 031219 20:52:52 /usr/libexec/mysqld: Normal shutdown > 881 > 882 031219 20:52:52 mysqld ended > > I've even tried moving host.frm around. > > The manual says that mysql_install_db may not have run or to try > > ./bin/safe_mysqld & > > I've tried all combinations of the above. > > ps -ef | grep -i sql shows nothing so the server is NOT running > > mysql does not work > ERROR 2002: Can't connect to local MySQL server through socket > '/var/lib/mysql/mysql.sock' (2) > > .......................................... PREVIOUS HISTORY > (1) performed a standard install of Redhat Linux 9 months ago > (I found mysql 3.23.52 installed) > I executed mysql_install_db successfully (manual says it is safe to > rerun) > installing all prepared tables > 031219 0:44:16 /usr/libexec/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: > /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 > > (3) tried debug > landon (root) /usr/bin [316]>!305 > cat /var/lib/mysql/xxx.log > /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 > > (5) also tried ./bin/safe_mysqld --user=mysql & > same result > > (6) tried > safe_mysqld --debug & > couldn't find the mysqld.trace file > > (7) mysql doesn't work > ERROR 2002: Can't connect to local MySQL server through socket > '/var/lib/mysql/mysql.sock' (2) > > _________________________________________________________________ > Grab our best dial-up Internet access 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]
