Mysqld fails to start
Hello List, mysqld fails to start, and emits the following error messages in /var/log/mysqld.log 090127 10:00:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql /usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist 090127 10:00:30 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 090127 10:00:30 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'open'. InnoDB: Cannot continue operation. 090127 10:00:30 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended So, I tried to run mysql_upgrade: # mysql_upgrade Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck'... mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect FATAL ERROR: Upgrade failed So, it seems like a chicken and egg thing??? Cannot run mysql_upgrade bcause the server is not running. Cannot run the server because I must first run mysql_upgrade. PS: I know nothing about configuring and setting up mysql. Amarok2 needs a running mysqld in order to organize music tracks collections ... etc. I need help to get mysqld started and running and to add users that are allowed to access and modify their databases. Could someone send me a set of user commands to get thing going? These are all the mysql related packages on my system: mysql-5.1.30-1.fc7.remi mysql-libs-5.1.30-1.fc7.remi sqlite-3.4.2-1.fc7 libdbi-dbd-pgsql-0.8.1a-2.fc7 sqlite-3.4.2-1.fc7 postgresql-libs-8.2.9-1.fc7 hsqldb-1.8.0.8-1jpp.5.fc7 postgresql-libs-8.2.9-1.fc7 mysql-server-5.1.30-1.fc7.remi mysqlclient15-5.0.67-1.fc7.remi mod_auth_mysql-3.0.0-3.1 mysqlclient15-5.0.67-1.fc7.remi sqlite2-2.8.17-1.fc6 php-pgsql-5.2.8-1.fc7.remi sqlite-devel-3.4.2-1.fc7 postgresql-python-8.2.9-1.fc7 postgresql-8.2.9-1.fc7 postgresql-server-8.2.9-1.fc7 mono-data-sqlite-1.2.3-5.fc7 mysql-devel-5.1.30-1.fc7.remi mysqlclient15-devel-5.0.67-1.fc7.remi mod_auth_pgsql-2.0.3-3 mysql-connector-odbc-3.51.12-2.2 libdbi-dbd-mysql-0.8.1a-2.fc7 mysqlclient15-devel-5.0.67-1.fc7.remi php-mysql-5.2.8-1.fc7.remi Cheers, JD -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Mysqld fails to start
Hello JD, You need to look beyond the first error messages: /usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist 090127 10:00:30 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. but keep reading: 090127 10:00:30 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'open'. InnoDB: Cannot continue operation. That's what is really keeping mysqld from starting. You just need to chown/chmod the data directory or run mysqld as the proper user. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Mysqld fails to start
Hi JD, I believe the error about mysql.plugin is a red herring - it needs fixing, but it's not the reason MySQL isn't starting. The second error is the one about InnoDB not having access rights to the directory. Check that /var/lib/mysql is writeable by the MySQL user (usually MySQL.) Make sure this is done, then MySQL will start, then you can run mysql_upgrade. HTH, Andy JD wrote: Hello List, mysqld fails to start, and emits the following error messages in /var/log/mysqld.log 090127 10:00:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql /usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist 090127 10:00:30 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 090127 10:00:30 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'open'. InnoDB: Cannot continue operation. 090127 10:00:30 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended So, I tried to run mysql_upgrade: # mysql_upgrade Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck'... mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect FATAL ERROR: Upgrade failed So, it seems like a chicken and egg thing??? Cannot run mysql_upgrade bcause the server is not running. Cannot run the server because I must first run mysql_upgrade. PS: I know nothing about configuring and setting up mysql. Amarok2 needs a running mysqld in order to organize music tracks collections ... etc. I need help to get mysqld started and running and to add users that are allowed to access and modify their databases. Could someone send me a set of user commands to get thing going? These are all the mysql related packages on my system: mysql-5.1.30-1.fc7.remi mysql-libs-5.1.30-1.fc7.remi sqlite-3.4.2-1.fc7 libdbi-dbd-pgsql-0.8.1a-2.fc7 sqlite-3.4.2-1.fc7 postgresql-libs-8.2.9-1.fc7 hsqldb-1.8.0.8-1jpp.5.fc7 postgresql-libs-8.2.9-1.fc7 mysql-server-5.1.30-1.fc7.remi mysqlclient15-5.0.67-1.fc7.remi mod_auth_mysql-3.0.0-3.1 mysqlclient15-5.0.67-1.fc7.remi sqlite2-2.8.17-1.fc6 php-pgsql-5.2.8-1.fc7.remi sqlite-devel-3.4.2-1.fc7 postgresql-python-8.2.9-1.fc7 postgresql-8.2.9-1.fc7 postgresql-server-8.2.9-1.fc7 mono-data-sqlite-1.2.3-5.fc7 mysql-devel-5.1.30-1.fc7.remi mysqlclient15-devel-5.0.67-1.fc7.remi mod_auth_pgsql-2.0.3-3 mysql-connector-odbc-3.51.12-2.2 libdbi-dbd-mysql-0.8.1a-2.fc7 mysqlclient15-devel-5.0.67-1.fc7.remi php-mysql-5.2.8-1.fc7.remi Cheers, JD -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Mysqld fails to start
JD wrote: Hello List, mysqld fails to start, and emits the following error messages in /var/log/mysqld.log 090127 10:00:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql /usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist 090127 10:00:30 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 090127 10:00:30 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. That's most likely to be the real error. Or, at least, the most important one. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'open'. InnoDB: Cannot continue operation. 090127 10:00:30 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended So, I tried to run mysql_upgrade: # mysql_upgrade Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck'... mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect FATAL ERROR: Upgrade failed So, it seems like a chicken and egg thing??? Cannot run mysql_upgrade bcause the server is not running. Cannot run the server because I must first run mysql_upgrade. I think you're being misled by the fact that there are two errors: A missing table and a file system that mysqld doesn't have access to. Fix the file permissions first, and then try starting mysqld. You'll then be able to run mysql_upgrade to fix the missing table problem (which is a warning, not a fatal error, hence why you need to have the server running to be able to fix it). Mark -- http://www.good-stuff.co.uk - Stuff, some of it good -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Mysqld fails to start
I am running as root. I dont understand what rights or permissions mysqld needs beyond those of root. Also, ./ibdata1 is relative to what path? I get this message no matter what dir is my current working dir. I searched in my home dir and in /root home dir. There is no such file or directory called ./ibdata1 nor is there any file or dir called mysql.plugin Wasnt mysqld supposed to create all that at startup?? This is what the top of the log file says: 071215 15:36:09 mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 071215 15:36:09 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 071215 15:36:10 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 071215 15:36:10 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 071215 15:36:10 InnoDB: Started; log sequence number 0 0 071215 15:36:10 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 071215 15:47:01 [Note] /usr/libexec/mysqld: Normal shutdown 071215 15:47:01 InnoDB: Starting shutdown... 071215 15:47:02 InnoDB: Shutdown completed; log sequence number 0 43655 071215 15:47:02 [Note] /usr/libexec/mysqld: Shutdown complete 071215 15:47:02 mysqld ended Then at re-start: 071215 15:47:17 mysqld started 071215 15:47:17 InnoDB: Started; log sequence number 0 43655 071215 15:47:17 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 071217 0:03:27 [Note] /usr/libexec/mysqld: Normal shutdown 071217 0:03:28 InnoDB: Starting shutdown... 071217 0:03:29 InnoDB: Shutdown completed; log sequence number 0 43655 071217 0:03:29 [Note] /usr/libexec/mysqld: Shutdown complete 071217 00:03:29 mysqld ended 090121 09:32:40 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql /usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist 090121 9:32:41 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 090121 9:32:41 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'open'. InnoDB: Cannot continue operation. 090121 09:32:41 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 090121 09:33:41 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql /usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist 090121 9:33:41 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. So, how are ibdata1 and mysql.plugin are supposed to be created? Baron Schwartz wrote: Hello JD, You need to look beyond the first error messages: /usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist 090127 10:00:30 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. but keep reading: 090127 10:00:30 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'open'. InnoDB: Cannot continue operation. That's what is really keeping mysqld from starting. You just need to chown/chmod the data directory or run mysqld as the proper user.
Re: Mysqld fails to start
Deamon runs as root. ls -ld /var/lib/mysql/ drwxr-xr-x 5 mysql mysql 4096 2009-01-27 10:00 /var/lib/mysql/ So what other perms does root need? Andy Shellam wrote: Hi JD, I believe the error about mysql.plugin is a red herring - it needs fixing, but it's not the reason MySQL isn't starting. The second error is the one about InnoDB not having access rights to the directory. Check that /var/lib/mysql is writeable by the MySQL user (usually MySQL.) Make sure this is done, then MySQL will start, then you can run mysql_upgrade. HTH, Andy JD wrote: Hello List, mysqld fails to start, and emits the following error messages in /var/log/mysqld.log 090127 10:00:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql /usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist 090127 10:00:30 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 090127 10:00:30 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'open'. InnoDB: Cannot continue operation. 090127 10:00:30 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended So, I tried to run mysql_upgrade: # mysql_upgrade Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck'... mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect FATAL ERROR: Upgrade failed So, it seems like a chicken and egg thing??? Cannot run mysql_upgrade bcause the server is not running. Cannot run the server because I must first run mysql_upgrade. PS: I know nothing about configuring and setting up mysql. Amarok2 needs a running mysqld in order to organize music tracks collections ... etc. I need help to get mysqld started and running and to add users that are allowed to access and modify their databases. Could someone send me a set of user commands to get thing going? These are all the mysql related packages on my system: mysql-5.1.30-1.fc7.remi mysql-libs-5.1.30-1.fc7.remi sqlite-3.4.2-1.fc7 libdbi-dbd-pgsql-0.8.1a-2.fc7 sqlite-3.4.2-1.fc7 postgresql-libs-8.2.9-1.fc7 hsqldb-1.8.0.8-1jpp.5.fc7 postgresql-libs-8.2.9-1.fc7 mysql-server-5.1.30-1.fc7.remi mysqlclient15-5.0.67-1.fc7.remi mod_auth_mysql-3.0.0-3.1 mysqlclient15-5.0.67-1.fc7.remi sqlite2-2.8.17-1.fc6 php-pgsql-5.2.8-1.fc7.remi sqlite-devel-3.4.2-1.fc7 postgresql-python-8.2.9-1.fc7 postgresql-8.2.9-1.fc7 postgresql-server-8.2.9-1.fc7 mono-data-sqlite-1.2.3-5.fc7 mysql-devel-5.1.30-1.fc7.remi mysqlclient15-devel-5.0.67-1.fc7.remi mod_auth_pgsql-2.0.3-3 mysql-connector-odbc-3.51.12-2.2 libdbi-dbd-mysql-0.8.1a-2.fc7 mysqlclient15-devel-5.0.67-1.fc7.remi php-mysql-5.2.8-1.fc7.remi Cheers, JD -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Mysqld fails to start
JD, please post the ouput from: ls -altr /var/lib/mysql thanks Claudio JD wrote: Deamon runs as root. ls -ld /var/lib/mysql/ drwxr-xr-x 5 mysql mysql 4096 2009-01-27 10:00 /var/lib/mysql/ So what other perms does root need? Andy Shellam wrote: Hi JD, I believe the error about mysql.plugin is a red herring - it needs fixing, but it's not the reason MySQL isn't starting. The second error is the one about InnoDB not having access rights to the directory. Check that /var/lib/mysql is writeable by the MySQL user (usually MySQL.) Make sure this is done, then MySQL will start, then you can run mysql_upgrade. HTH, Andy JD wrote: Hello List, mysqld fails to start, and emits the following error messages in /var/log/mysqld.log 090127 10:00:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql /usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist 090127 10:00:30 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 090127 10:00:30 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'open'. InnoDB: Cannot continue operation. 090127 10:00:30 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended So, I tried to run mysql_upgrade: # mysql_upgrade Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck'... mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect FATAL ERROR: Upgrade failed So, it seems like a chicken and egg thing??? Cannot run mysql_upgrade bcause the server is not running. Cannot run the server because I must first run mysql_upgrade. PS: I know nothing about configuring and setting up mysql. Amarok2 needs a running mysqld in order to organize music tracks collections ... etc. I need help to get mysqld started and running and to add users that are allowed to access and modify their databases. Could someone send me a set of user commands to get thing going? These are all the mysql related packages on my system: mysql-5.1.30-1.fc7.remi mysql-libs-5.1.30-1.fc7.remi sqlite-3.4.2-1.fc7 libdbi-dbd-pgsql-0.8.1a-2.fc7 sqlite-3.4.2-1.fc7 postgresql-libs-8.2.9-1.fc7 hsqldb-1.8.0.8-1jpp.5.fc7 postgresql-libs-8.2.9-1.fc7 mysql-server-5.1.30-1.fc7.remi mysqlclient15-5.0.67-1.fc7.remi mod_auth_mysql-3.0.0-3.1 mysqlclient15-5.0.67-1.fc7.remi sqlite2-2.8.17-1.fc6 php-pgsql-5.2.8-1.fc7.remi sqlite-devel-3.4.2-1.fc7 postgresql-python-8.2.9-1.fc7 postgresql-8.2.9-1.fc7 postgresql-server-8.2.9-1.fc7 mono-data-sqlite-1.2.3-5.fc7 mysql-devel-5.1.30-1.fc7.remi mysqlclient15-devel-5.0.67-1.fc7.remi mod_auth_pgsql-2.0.3-3 mysql-connector-odbc-3.51.12-2.2 libdbi-dbd-mysql-0.8.1a-2.fc7 mysqlclient15-devel-5.0.67-1.fc7.remi php-mysql-5.2.8-1.fc7.remi Cheers, JD -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Mysqld fails to start
ls -altr /var/lib/mysql total 20548K drwxr-xr-x 2 mysql mysql 4096 2007-12-15 15:36 test/ -rw-r--r-- 1 mysql mysql 5242880 2007-12-15 15:36 ib_logfile1 drwxr-xr-x 2 mysql mysql 4096 2007-12-15 16:10 ampache/ -rw-r--r-- 1 mysql mysql 10485760 2007-12-17 00:03 ibdata1 drwxr-xr-x 2 mysql mysql 4096 2009-01-21 14:12 mysql/ srwxrwxrwx 1 mysql mysql0 2009-01-27 14:13 mysql.sock= -rw-r--r-- 1 mysql mysql 5242880 2009-01-27 14:13 ib_logfile0 drwxr-xr-x 53 root root 4096 2009-01-27 14:14 ../ drwxr-xr-x 5 mysql mysql 4096 2009-01-27 15:48 ./ Claudio Nanni wrote: JD, please post the ouput from: ls -altr /var/lib/mysql thanks Claudio JD wrote: Deamon runs as root. ls -ld /var/lib/mysql/ drwxr-xr-x 5 mysql mysql 4096 2009-01-27 10:00 /var/lib/mysql/ So what other perms does root need? Andy Shellam wrote: Hi JD, I believe the error about mysql.plugin is a red herring - it needs fixing, but it's not the reason MySQL isn't starting. The second error is the one about InnoDB not having access rights to the directory. Check that /var/lib/mysql is writeable by the MySQL user (usually MySQL.) Make sure this is done, then MySQL will start, then you can run mysql_upgrade. HTH, Andy JD wrote: Hello List, mysqld fails to start, and emits the following error messages in /var/log/mysqld.log 090127 10:00:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql /usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist 090127 10:00:30 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 090127 10:00:30 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'open'. InnoDB: Cannot continue operation. 090127 10:00:30 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended So, I tried to run mysql_upgrade: # mysql_upgrade Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck'... mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect FATAL ERROR: Upgrade failed So, it seems like a chicken and egg thing??? Cannot run mysql_upgrade bcause the server is not running. Cannot run the server because I must first run mysql_upgrade. PS: I know nothing about configuring and setting up mysql. Amarok2 needs a running mysqld in order to organize music tracks collections ... etc. I need help to get mysqld started and running and to add users that are allowed to access and modify their databases. Could someone send me a set of user commands to get thing going? These are all the mysql related packages on my system: mysql-5.1.30-1.fc7.remi mysql-libs-5.1.30-1.fc7.remi sqlite-3.4.2-1.fc7 libdbi-dbd-pgsql-0.8.1a-2.fc7 sqlite-3.4.2-1.fc7 postgresql-libs-8.2.9-1.fc7 hsqldb-1.8.0.8-1jpp.5.fc7 postgresql-libs-8.2.9-1.fc7 mysql-server-5.1.30-1.fc7.remi mysqlclient15-5.0.67-1.fc7.remi mod_auth_mysql-3.0.0-3.1 mysqlclient15-5.0.67-1.fc7.remi sqlite2-2.8.17-1.fc6 php-pgsql-5.2.8-1.fc7.remi sqlite-devel-3.4.2-1.fc7 postgresql-python-8.2.9-1.fc7 postgresql-8.2.9-1.fc7 postgresql-server-8.2.9-1.fc7 mono-data-sqlite-1.2.3-5.fc7 mysql-devel-5.1.30-1.fc7.remi mysqlclient15-devel-5.0.67-1.fc7.remi mod_auth_pgsql-2.0.3-3 mysql-connector-odbc-3.51.12-2.2 libdbi-dbd-mysql-0.8.1a-2.fc7 mysqlclient15-devel-5.0.67-1.fc7.remi php-mysql-5.2.8-1.fc7.remi Cheers, JD -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Mysqld fails to start
Ah, try this: chmod ug+rw ibdata1 and the same for your iblogfile0 and iblogfile1 files.. Walter OlinData: Professional services for MySQL Support * Consulting * Administration http://www.olindata.com On Wed, Jan 28, 2009 at 12:48 AM, JD jd1...@gmail.com wrote: ls -altr /var/lib/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Mysqld fails to start
Hi JD, just try a simple thing, rm /var/lib/mysql/ib_logfile1 rm /var/lib/mysql/ib_logfile2 to remove the innodb log files, sometimes you can have this problems, did you copy the database between servers? where are the .pid and .err files? Claudio 2009/1/28 JD jd1...@gmail.com ls -altr /var/lib/mysql total 20548K drwxr-xr-x 2 mysql mysql 4096 2007-12-15 15:36 test/ -rw-r--r-- 1 mysql mysql 5242880 2007-12-15 15:36 ib_logfile1 drwxr-xr-x 2 mysql mysql 4096 2007-12-15 16:10 ampache/ -rw-r--r-- 1 mysql mysql 10485760 2007-12-17 00:03 ibdata1 drwxr-xr-x 2 mysql mysql 4096 2009-01-21 14:12 mysql/ srwxrwxrwx 1 mysql mysql0 2009-01-27 14:13 mysql.sock= -rw-r--r-- 1 mysql mysql 5242880 2009-01-27 14:13 ib_logfile0 drwxr-xr-x 53 root root 4096 2009-01-27 14:14 ../ drwxr-xr-x 5 mysql mysql 4096 2009-01-27 15:48 ./ Claudio Nanni wrote: JD, please post the ouput from: ls -altr /var/lib/mysql thanks Claudio JD wrote: Deamon runs as root. ls -ld /var/lib/mysql/ drwxr-xr-x 5 mysql mysql 4096 2009-01-27 10:00 /var/lib/mysql/ So what other perms does root need? Andy Shellam wrote: Hi JD, I believe the error about mysql.plugin is a red herring - it needs fixing, but it's not the reason MySQL isn't starting. The second error is the one about InnoDB not having access rights to the directory. Check that /var/lib/mysql is writeable by the MySQL user (usually MySQL.) Make sure this is done, then MySQL will start, then you can run mysql_upgrade. HTH, Andy JD wrote: Hello List, mysqld fails to start, and emits the following error messages in /var/log/mysqld.log 090127 10:00:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql /usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist 090127 10:00:30 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 090127 10:00:30 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'open'. InnoDB: Cannot continue operation. 090127 10:00:30 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended So, I tried to run mysql_upgrade: # mysql_upgrade Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck'... mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect FATAL ERROR: Upgrade failed So, it seems like a chicken and egg thing??? Cannot run mysql_upgrade bcause the server is not running. Cannot run the server because I must first run mysql_upgrade. PS: I know nothing about configuring and setting up mysql. Amarok2 needs a running mysqld in order to organize music tracks collections ... etc. I need help to get mysqld started and running and to add users that are allowed to access and modify their databases. Could someone send me a set of user commands to get thing going? These are all the mysql related packages on my system: mysql-5.1.30-1.fc7.remi mysql-libs-5.1.30-1.fc7.remi sqlite-3.4.2-1.fc7 libdbi-dbd-pgsql-0.8.1a-2.fc7 sqlite-3.4.2-1.fc7 postgresql-libs-8.2.9-1.fc7 hsqldb-1.8.0.8-1jpp.5.fc7 postgresql-libs-8.2.9-1.fc7 mysql-server-5.1.30-1.fc7.remi mysqlclient15-5.0.67-1.fc7.remi mod_auth_mysql-3.0.0-3.1 mysqlclient15-5.0.67-1.fc7.remi sqlite2-2.8.17-1.fc6 php-pgsql-5.2.8-1.fc7.remi sqlite-devel-3.4.2-1.fc7 postgresql-python-8.2.9-1.fc7 postgresql-8.2.9-1.fc7 postgresql-server-8.2.9-1.fc7 mono-data-sqlite-1.2.3-5.fc7 mysql-devel-5.1.30-1.fc7.remi mysqlclient15-devel-5.0.67-1.fc7.remi mod_auth_pgsql-2.0.3-3 mysql-connector-odbc-3.51.12-2.2 libdbi-dbd-mysql-0.8.1a-2.fc7 mysqlclient15-devel-5.0.67-1.fc7.remi php-mysql-5.2.8-1.fc7.remi Cheers, JD -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com
Re: Mysqld fails to start
I did the chmod. Then # ls -latrR /var/lib/mysql /var/lib/mysql: total 20548K drwxrwxr-x 2 mysql mysql 4096 2007-12-15 15:36 test/ -rw-rw-r-- 1 mysql mysql 5242880 2007-12-15 15:36 ib_logfile1 drwxrwxr-x 2 mysql mysql 4096 2007-12-15 16:10 ampache/ drwxrwxr-x 2 mysql mysql 4096 2009-01-21 14:12 mysql/ drwxr-xr-x 53 root root 4096 2009-01-27 14:14 ../ srwxrwxrwx 1 mysql mysql0 2009-01-27 16:35 mysql.sock= -rw-rw-r-- 1 mysql mysql 5242880 2009-01-27 16:35 ib_logfile0 -rw-rw-r-- 1 mysql mysql 10485760 2009-01-27 16:35 ibdata1 drwxrwxr-x 5 mysql mysql 4096 2009-01-27 16:35 ./ /var/lib/mysql/test: total 12K drwxrwxr-x 2 mysql mysql 4096 2007-12-15 15:36 ./ drwxrwxr-x 5 mysql mysql 4096 2009-01-27 16:35 ../ /var/lib/mysql/ampache: total 16K -rw-rw-r-- 1 mysql mysql 65 2007-12-15 16:10 db.opt drwxrwxr-x 2 mysql mysql 4096 2007-12-15 16:10 ./ drwxrwxr-x 5 mysql mysql 4096 2009-01-27 16:35 ../ /var/lib/mysql/mysql: total 788K -rw-rw-r-- 1 mysql mysql 10330 2007-12-15 15:36 user.frm -rw-rw-r-- 1 mysql mysql 1024 2007-12-15 15:36 time_zone_transition_type.MYI -rw-rw-r-- 1 mysql mysql 0 2007-12-15 15:36 time_zone_transition_type.MYD -rw-rw-r-- 1 mysql mysql 8748 2007-12-15 15:36 time_zone_transition_type.frm -rw-rw-r-- 1 mysql mysql 1024 2007-12-15 15:36 time_zone_transition.MYI -rw-rw-r-- 1 mysql mysql 0 2007-12-15 15:36 time_zone_transition.MYD -rw-rw-r-- 1 mysql mysql 8686 2007-12-15 15:36 time_zone_transition.frm -rw-rw-r-- 1 mysql mysql 1024 2007-12-15 15:36 time_zone_name.MYI -rw-rw-r-- 1 mysql mysql 0 2007-12-15 15:36 time_zone_name.MYD -rw-rw-r-- 1 mysql mysql 8606 2007-12-15 15:36 time_zone_name.frm -rw-rw-r-- 1 mysql mysql 1024 2007-12-15 15:36 time_zone.MYI -rw-rw-r-- 1 mysql mysql 0 2007-12-15 15:36 time_zone.MYD -rw-rw-r-- 1 mysql mysql 1024 2007-12-15 15:36 time_zone_leap_second.MYI -rw-rw-r-- 1 mysql mysql 0 2007-12-15 15:36 time_zone_leap_second.MYD -rw-rw-r-- 1 mysql mysql 8624 2007-12-15 15:36 time_zone_leap_second.frm -rw-rw-r-- 1 mysql mysql 8636 2007-12-15 15:36 time_zone.frm -rw-rw-r-- 1 mysql mysql 1024 2007-12-15 15:36 tables_priv.MYI -rw-rw-r-- 1 mysql mysql 0 2007-12-15 15:36 tables_priv.MYD -rw-rw-r-- 1 mysql mysql 8947 2007-12-15 15:36 tables_priv.frm -rw-rw-r-- 1 mysql mysql 1024 2007-12-15 15:36 procs_priv.MYI -rw-rw-r-- 1 mysql mysql 0 2007-12-15 15:36 procs_priv.MYD -rw-rw-r-- 1 mysql mysql 8875 2007-12-15 15:36 procs_priv.frm -rw-rw-r-- 1 mysql mysql 1024 2007-12-15 15:36 proc.MYI -rw-rw-r-- 1 mysql mysql 0 2007-12-15 15:36 proc.MYD -rw-rw-r-- 1 mysql mysql 9691 2007-12-15 15:36 proc.frm -rw-rw-r-- 1 mysql mysql 1024 2007-12-15 15:36 host.MYI -rw-rw-r-- 1 mysql mysql 0 2007-12-15 15:36 host.MYD -rw-rw-r-- 1 mysql mysql 9416 2007-12-15 15:36 host.frm -rw-rw-r-- 1 mysql mysql 17408 2007-12-15 15:36 help_topic.MYI -rw-rw-r-- 1 mysql mysql 333276 2007-12-15 15:36 help_topic.MYD -rw-rw-r-- 1 mysql mysql 8770 2007-12-15 15:36 help_topic.frm -rw-rw-r-- 1 mysql mysql 15360 2007-12-15 15:36 help_relation.MYI -rw-rw-r-- 1 mysql mysql 7281 2007-12-15 15:36 help_relation.MYD -rw-rw-r-- 1 mysql mysql 8630 2007-12-15 15:36 help_relation.frm -rw-rw-r-- 1 mysql mysql 14336 2007-12-15 15:36 help_keyword.MYI -rw-rw-r-- 1 mysql mysql 77815 2007-12-15 15:36 help_keyword.MYD -rw-rw-r-- 1 mysql mysql 8612 2007-12-15 15:36 help_keyword.frm -rw-rw-r-- 1 mysql mysql 3072 2007-12-15 15:36 help_category.MYI -rw-rw-r-- 1 mysql mysql 20916 2007-12-15 15:36 help_category.MYD -rw-rw-r-- 1 mysql mysql 8700 2007-12-15 15:36 help_category.frm -rw-rw-r-- 1 mysql mysql 1024 2007-12-15 15:36 func.MYI -rw-rw-r-- 1 mysql mysql 0 2007-12-15 15:36 func.MYD -rw-rw-r-- 1 mysql mysql 8665 2007-12-15 15:36 func.frm -rw-rw-r-- 1 mysql mysql 9494 2007-12-15 15:36 db.frm -rw-rw-r-- 1 mysql mysql 1024 2007-12-15 15:36 columns_priv.MYI -rw-rw-r-- 1 mysql mysql 0 2007-12-15 15:36 columns_priv.MYD -rw-rw-r-- 1 mysql mysql 8820 2007-12-15 15:36 columns_priv.frm -rw-rw-r-- 1 mysql mysql256 2007-12-15 16:10 user.MYD -rw-rw-r-- 1 mysql mysql 1314 2007-12-15 16:10 db.MYD -rw-rw-r-- 1 mysql mysql 2048 2007-12-17 00:03 user.MYI -rw-rw-r-- 1 mysql mysql 4096 2007-12-17 00:03 db.MYI drwxrwxr-x 2 mysql mysql 4096 2009-01-21 14:12 ./ -rw-rw 1 mysql mysql 12288 2009-01-21 14:12 .swp drwxrwxr-x 5 mysql mysql 4096 2009-01-27 16:35 ../ I restarted mysqld (service mysqld restart) and this is what got written in the mysql.log 090127 16:40:09 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql /usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist 090127 16:40:09 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 090127 16:40:09 InnoDB: Started; log sequence number 0 43655 090127 16:40:09 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 090127 16:40:09 [ERROR] Column count of
Re: Mysqld fails to start
I stopped mysqld. I removed those logfiles I did not copy any databe between servers. I only have one machine. I would not even know what to copy, as I know nothing about databases. I have no idea where the .pid and the .err files came from. I restarted the daemon, and this is what it wrote into the /var/messages/mysqd.log 090127 16:54:15 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql /usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist 090127 16:54:15 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 090127 16:54:15 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 090127 16:54:15 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 090127 16:54:15 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 090127 16:54:15 InnoDB: Started; log sequence number 0 44044 090127 16:54:15 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 090127 16:54:15 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50045, now running 50130. Please use mysql_upgrade to fix this error. 090127 16:54:15 [ERROR] mysql.user has no `Event_priv` column at position 29 090127 16:54:15 [ERROR] Cannot open mysql.event 090127 16:54:15 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler. 090127 16:54:15 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.1.30' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) by Remi Claudio Nanni wrote: Hi JD, just try a simple thing, rm /var/lib/mysql/ib_logfile1 rm /var/lib/mysql/ib_logfile2 to remove the innodb log files, sometimes you can have this problems, did you copy the database between servers? where are the .pid and .err files? Claudio 2009/1/28 JD jd1...@gmail.com mailto:jd1...@gmail.com ls -altr /var/lib/mysql total 20548K drwxr-xr-x 2 mysql mysql 4096 2007-12-15 15:36 test/ -rw-r--r-- 1 mysql mysql 5242880 2007-12-15 15:36 ib_logfile1 drwxr-xr-x 2 mysql mysql 4096 2007-12-15 16:10 ampache/ -rw-r--r-- 1 mysql mysql 10485760 2007-12-17 00:03 ibdata1 drwxr-xr-x 2 mysql mysql 4096 2009-01-21 14:12 mysql/ srwxrwxrwx 1 mysql mysql0 2009-01-27 14:13 mysql.sock= -rw-r--r-- 1 mysql mysql 5242880 2009-01-27 14:13 ib_logfile0 drwxr-xr-x 53 root root 4096 2009-01-27 14:14 ../ drwxr-xr-x 5 mysql mysql 4096 2009-01-27 15:48 ./ Claudio Nanni wrote: JD, please post the ouput from: ls -altr /var/lib/mysql thanks Claudio JD wrote: Deamon runs as root. ls -ld /var/lib/mysql/ drwxr-xr-x 5 mysql mysql 4096 2009-01-27 10:00 /var/lib/mysql/ So what other perms does root need? Andy Shellam wrote: Hi JD, I believe the error about mysql.plugin is a red herring - it needs fixing, but it's not the reason MySQL isn't starting. The second error is the one about InnoDB not having access rights to the directory. Check that /var/lib/mysql is writeable by the MySQL user (usually MySQL.) Make sure this is done, then MySQL will start, then you can run mysql_upgrade. HTH, Andy JD wrote: Hello List, mysqld fails to start, and emits the following error messages in /var/log/mysqld.log 090127 10:00:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql /usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist 090127 10:00:30 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 090127 10:00:30 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'open'. InnoDB: Cannot continue operation. 090127 10
Re: Mysqld fails to start
OK, I located a weblog on how to change the password and it worked. I then stopped and started the serever, and this is what it belched out in the mysqld.log: 090127 18:17:16 [Note] /usr/libexec/mysqld: Normal shutdown 090127 18:17:16 InnoDB: Starting shutdown... 090127 18:17:17 InnoDB: Shutdown completed; log sequence number 0 44044 090127 18:17:17 [Note] /usr/libexec/mysqld: Shutdown complete 090127 18:17:17 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 090127 18:17:18 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql /usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist 090127 18:17:18 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 090127 18:17:18 InnoDB: Started; log sequence number 0 44044 090127 18:17:18 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 090127 18:17:18 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50045, now running 50130. Please use mysql_upgrade to fix this error. 090127 18:17:18 [ERROR] mysql.user has no `Event_priv` column at position 29 090127 18:17:18 [ERROR] Cannot open mysql.event 090127 18:17:18 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler. 090127 18:17:18 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.1.30' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) by Remi So, how do I fix those errors about 'mysql.plugin' and mysql.db and mysql.user For that matter why does it even have a mysql.user ??? Should it not be mysql.root? Walter Heck wrote: We're slowly getting there ;) that is the root account for the mysql server, not the linux root account :) when you installed mysql, you chose a root password. If you didn't, look up how to reset your mysql root account's password. Plenty of info on the web :) good luck! Walter OlinData: Professional services for MySQL Support * Consulting * Administration http://www.olindata.com On Wed, Jan 28, 2009 at 1:47 AM, JD jd1...@gmail.com wrote: I did the chmod. Then # ls -latrR /var/lib/mysql /var/lib/mysql: total 20548K drwxrwxr-x 2 mysql mysql 4096 2007-12-15 15:36 test/ -rw-rw-r-- 1 mysql mysql 5242880 2007-12-15 15:36 ib_logfile1 drwxrwxr-x 2 mysql mysql 4096 2007-12-15 16:10 ampache/ drwxrwxr-x 2 mysql mysql 4096 2009-01-21 14:12 mysql/ drwxr-xr-x 53 root root 4096 2009-01-27 14:14 ../ srwxrwxrwx 1 mysql mysql0 2009-01-27 16:35 mysql.sock= -rw-rw-r-- 1 mysql mysql 5242880 2009-01-27 16:35 ib_logfile0 -rw-rw-r-- 1 mysql mysql 10485760 2009-01-27 16:35 ibdata1 drwxrwxr-x 5 mysql mysql 4096 2009-01-27 16:35 ./ /var/lib/mysql/test: total 12K drwxrwxr-x 2 mysql mysql 4096 2007-12-15 15:36 ./ drwxrwxr-x 5 mysql mysql 4096 2009-01-27 16:35 ../ /var/lib/mysql/ampache: total 16K -rw-rw-r-- 1 mysql mysql 65 2007-12-15 16:10 db.opt drwxrwxr-x 2 mysql mysql 4096 2007-12-15 16:10 ./ drwxrwxr-x 5 mysql mysql 4096 2009-01-27 16:35 ../ /var/lib/mysql/mysql: total 788K -rw-rw-r-- 1 mysql mysql 10330 2007-12-15 15:36 user.frm -rw-rw-r-- 1 mysql mysql 1024 2007-12-15 15:36 time_zone_transition_type.MYI -rw-rw-r-- 1 mysql mysql 0 2007-12-15 15:36 time_zone_transition_type.MYD -rw-rw-r-- 1 mysql mysql 8748 2007-12-15 15:36 time_zone_transition_type.frm -rw-rw-r-- 1 mysql mysql 1024 2007-12-15 15:36 time_zone_transition.MYI -rw-rw-r-- 1 mysql mysql 0 2007-12-15 15:36 time_zone_transition.MYD -rw-rw-r-- 1 mysql mysql 8686 2007-12-15 15:36 time_zone_transition.frm -rw-rw-r-- 1 mysql mysql 1024 2007-12-15 15:36 time_zone_name.MYI -rw-rw-r-- 1 mysql mysql 0 2007-12-15 15:36 time_zone_name.MYD -rw-rw-r-- 1 mysql mysql 8606 2007-12-15 15:36 time_zone_name.frm -rw-rw-r-- 1 mysql mysql 1024 2007-12-15 15:36 time_zone.MYI -rw-rw-r-- 1 mysql mysql 0 2007-12-15 15:36 time_zone.MYD -rw-rw-r-- 1 mysql mysql 1024 2007-12-15 15:36 time_zone_leap_second.MYI -rw-rw-r-- 1 mysql mysql 0 2007-12-15 15:36 time_zone_leap_second.MYD -rw-rw-r-- 1 mysql mysql 8624 2007-12-15 15:36 time_zone_leap_second.frm -rw-rw-r-- 1 mysql mysql 8636 2007-12-15 15:36 time_zone.frm -rw-rw-r-- 1 mysql mysql 1024 2007-12-15 15:36 tables_priv.MYI -rw-rw-r-- 1 mysql mysql 0 2007-12-15 15:36 tables_priv.MYD -rw-rw-r-- 1 mysql mysql 8947 2007-12-15 15:36 tables_priv.frm -rw-rw-r-- 1 mysql mysql 1024 2007-12-15 15:36 procs_priv.MYI -rw-rw-r-- 1 mysql mysql 0 2007-12-15 15:36 procs_priv.MYD -rw-rw-r-- 1 mysql mysql 8875 2007-12-15 15:36 procs_priv.frm -rw-rw-r-- 1 mysql mysql 1024 2007-12-15 15:36 proc.MYI -rw-rw-r-- 1 mysql mysql 0 2007-12-15 15:36 proc.MYD -rw-rw-r-- 1 mysql mysql 9691 2007-12-15 15:36 proc.frm -rw-rw-r-- 1 mysql mysql 1024 2007-12-15 15:36 host.MYI -rw-rw-r-- 1 mysql mysql 0 2007-12-15 15:36 host.MYD -rw-rw-r-- 1 mysql mysql 9416 2007-12-15 15:36 host.frm -rw-rw-r-- 1
Re: Mysqld fails to start
mysql.user is a table name, it is in the form of database_name.table_name. Mysql has a system database conveniently called mysql :) 090127 18:17:18 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50045, now running 50130. Please use mysql_upgrade to fix this error. I don't know how you got to where you are now, but it seems like your system database is from MySQL 5.0.45, while you seem to be running 5.1.30. couple of options: 1) try mysql_upgrade again, using root and it's password this time 2) remove the mysql dir inside /var/lib/mysql and then use mysql_install_db to recreate them properly 3) just remove mysql completely and reinstall from scratch Normally I would recommend 2, but in your case I would probably recommend 3 since you just need mysql to run amarok2 (i would recommend songbird anyway: http://www.getsongbird.com/ ;) ) and are not planning on doing anything serious with mysql. Depending on the distro you are using, it can be as simple as yum remove mysql and yum install mysql (removing /var/lib/mysql in between). Your choice though :) good luck! Walter can you try running mysql_upgrade OlinData: Professional services for MySQL Support * Consulting * Administration http://www.olindata.com On Wed, Jan 28, 2009 at 3:21 AM, JD jd1...@gmail.com wrote: OK, I located a weblog on how to change the password and it worked. I then stopped and started the serever, and this is what it belched out in the mysqld.log: 090127 18:17:16 [Note] /usr/libexec/mysqld: Normal shutdown 090127 18:17:16 InnoDB: Starting shutdown... 090127 18:17:17 InnoDB: Shutdown completed; log sequence number 0 44044 090127 18:17:17 [Note] /usr/libexec/mysqld: Shutdown complete 090127 18:17:17 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 090127 18:17:18 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql /usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist 090127 18:17:18 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 090127 18:17:18 InnoDB: Started; log sequence number 0 44044 090127 18:17:18 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 090127 18:17:18 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50045, now running 50130. Please use mysql_upgrade to fix this error. 090127 18:17:18 [ERROR] mysql.user has no `Event_priv` column at position 29 090127 18:17:18 [ERROR] Cannot open mysql.event 090127 18:17:18 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler. 090127 18:17:18 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.1.30' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) by Remi So, how do I fix those errors about 'mysql.plugin' and mysql.db and mysql.user For that matter why does it even have a mysql.user ??? Should it not be mysql.root? Walter Heck wrote: We're slowly getting there ;) that is the root account for the mysql server, not the linux root account :) when you installed mysql, you chose a root password. If you didn't, look up how to reset your mysql root account's password. Plenty of info on the web :) good luck! Walter OlinData: Professional services for MySQL Support * Consulting * Administration http://www.olindata.com On Wed, Jan 28, 2009 at 1:47 AM, JD jd1...@gmail.com wrote: I did the chmod. Then # ls -latrR /var/lib/mysql /var/lib/mysql: total 20548K drwxrwxr-x 2 mysql mysql 4096 2007-12-15 15:36 test/ -rw-rw-r-- 1 mysql mysql 5242880 2007-12-15 15:36 ib_logfile1 drwxrwxr-x 2 mysql mysql 4096 2007-12-15 16:10 ampache/ drwxrwxr-x 2 mysql mysql 4096 2009-01-21 14:12 mysql/ drwxr-xr-x 53 root root 4096 2009-01-27 14:14 ../ srwxrwxrwx 1 mysql mysql0 2009-01-27 16:35 mysql.sock= -rw-rw-r-- 1 mysql mysql 5242880 2009-01-27 16:35 ib_logfile0 -rw-rw-r-- 1 mysql mysql 10485760 2009-01-27 16:35 ibdata1 drwxrwxr-x 5 mysql mysql 4096 2009-01-27 16:35 ./ /var/lib/mysql/test: total 12K drwxrwxr-x 2 mysql mysql 4096 2007-12-15 15:36 ./ drwxrwxr-x 5 mysql mysql 4096 2009-01-27 16:35 ../ /var/lib/mysql/ampache: total 16K -rw-rw-r-- 1 mysql mysql 65 2007-12-15 16:10 db.opt drwxrwxr-x 2 mysql mysql 4096 2007-12-15 16:10 ./ drwxrwxr-x 5 mysql mysql 4096 2009-01-27 16:35 ../ /var/lib/mysql/mysql: total 788K -rw-rw-r-- 1 mysql mysql 10330 2007-12-15 15:36 user.frm -rw-rw-r-- 1 mysql mysql 1024 2007-12-15 15:36 time_zone_transition_type.MYI -rw-rw-r-- 1 mysql mysql 0 2007-12-15 15:36 time_zone_transition_type.MYD -rw-rw-r-- 1 mysql mysql 8748 2007-12-15 15:36 time_zone_transition_type.frm -rw-rw-r-- 1 mysql mysql 1024 2007-12-15 15:36 time_zone_transition.MYI -rw-rw-r-- 1 mysql mysql 0 2007-12-15 15:36 time_zone_transition.MYD -rw-rw-r-- 1 mysql mysql 8686 2007-12-15 15:36
Re: Mysqld fails to start
Problem with yum remove mysql is that it will also remove all it's dependents, whereas yum install mysql will not restore the dependents. Also, you are probably right re: 5.0.x and 5.1.x At anywho, I ran: }# mysql_upgrade --user=root --password='theNewPassword' Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck'... mysql.columns_priv OK mysql.db OK mysql.func OK mysql.help_category error: Table upgrade required. Please do REPAIR TABLE `help_category` to fix it! mysql.help_keyword error: Table upgrade required. Please do REPAIR TABLE `help_keyword` to fix it! mysql.help_relationOK mysql.help_topic error: Table upgrade required. Please do REPAIR TABLE `help_topic` to fix it! mysql.host OK mysql.proc error: Table upgrade required. Please do REPAIR TABLE `proc` to fix it! mysql.procs_priv OK mysql.tables_priv OK mysql.time_zoneOK mysql.time_zone_leap_secondOK mysql.time_zone_name error: Table upgrade required. Please do REPAIR TABLE `time_zone_name` to fix it! mysql.time_zone_transition OK mysql.time_zone_transition_typeOK mysql.user OK Repairing tables mysql.help_categoryOK mysql.help_keyword OK mysql.help_topic OK mysql.proc OK mysql.time_zone_name OK Running 'mysql_fix_privilege_tables'... OK So, you want me to 1. Stop the server 2. Remove /var/lib/mysql/mysql right? 3. Restart the server Correct? Walter Heck wrote: mysql.user is a table name, it is in the form of database_name.table_name. Mysql has a system database conveniently called mysql :) 090127 18:17:18 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50045, now running 50130. Please use mysql_upgrade to fix this error. I don't know how you got to where you are now, but it seems like your system database is from MySQL 5.0.45, while you seem to be running 5.1.30. couple of options: 1) try mysql_upgrade again, using root and it's password this time 2) remove the mysql dir inside /var/lib/mysql and then use mysql_install_db to recreate them properly 3) just remove mysql completely and reinstall from scratch Normally I would recommend 2, but in your case I would probably recommend 3 since you just need mysql to run amarok2 (i would recommend songbird anyway: http://www.getsongbird.com/ ;) ) and are not planning on doing anything serious with mysql. Depending on the distro you are using, it can be as simple as yum remove mysql and yum install mysql (removing /var/lib/mysql in between). Your choice though :) good luck! Walter can you try running mysql_upgrade OlinData: Professional services for MySQL Support * Consulting * Administration http://www.olindata.com On Wed, Jan 28, 2009 at 3:21 AM, JD jd1...@gmail.com wrote: OK, I located a weblog on how to change the password and it worked. I then stopped and started the serever, and this is what it belched out in the mysqld.log: 090127 18:17:16 [Note] /usr/libexec/mysqld: Normal shutdown 090127 18:17:16 InnoDB: Starting shutdown... 090127 18:17:17 InnoDB: Shutdown completed; log sequence number 0 44044 090127 18:17:17 [Note] /usr/libexec/mysqld: Shutdown complete 090127 18:17:17 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 090127 18:17:18 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql /usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist 090127 18:17:18 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 090127 18:17:18 InnoDB: Started; log sequence number 0 44044 090127 18:17:18 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 090127 18:17:18 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50045, now running 50130. Please use mysql_upgrade to fix this error. 090127 18:17:18 [ERROR] mysql.user has no `Event_priv` column at position 29 090127 18:17:18 [ERROR] Cannot open mysql.event 090127 18:17:18 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler. 090127 18:17:18 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.1.30' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) by Remi So, how do I fix those errors about 'mysql.plugin' and mysql.db and mysql.user For that matter why does it even have a mysql.user ??? Should it not be mysql.root? Walter Heck
Re: Mysqld fails to start
Actually, just restarting the server should do the trick. It seems like mysql_upgrade did it's job correctly. Can you restart teh server and check the logs? Walter OlinData: Professional services for MySQL Support * Consulting * Administration http://www.olindata.com On Wed, Jan 28, 2009 at 4:13 AM, JD jd1...@gmail.com wrote: Problem with yum remove mysql is that it will also remove all it's dependents, whereas yum install mysql will not restore the dependents. Also, you are probably right re: 5.0.x and 5.1.x At anywho, I ran: }# mysql_upgrade --user=root --password='theNewPassword' Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck'... mysql.columns_priv OK mysql.db OK mysql.func OK mysql.help_category error: Table upgrade required. Please do REPAIR TABLE `help_category` to fix it! mysql.help_keyword error: Table upgrade required. Please do REPAIR TABLE `help_keyword` to fix it! mysql.help_relationOK mysql.help_topic error: Table upgrade required. Please do REPAIR TABLE `help_topic` to fix it! mysql.host OK mysql.proc error: Table upgrade required. Please do REPAIR TABLE `proc` to fix it! mysql.procs_priv OK mysql.tables_priv OK mysql.time_zoneOK mysql.time_zone_leap_secondOK mysql.time_zone_name error: Table upgrade required. Please do REPAIR TABLE `time_zone_name` to fix it! mysql.time_zone_transition OK mysql.time_zone_transition_typeOK mysql.user OK Repairing tables mysql.help_categoryOK mysql.help_keyword OK mysql.help_topic OK mysql.proc OK mysql.time_zone_name OK Running 'mysql_fix_privilege_tables'... OK So, you want me to 1. Stop the server 2. Remove /var/lib/mysql/mysql right? 3. Restart the server Correct? Walter Heck wrote: mysql.user is a table name, it is in the form of database_name.table_name. Mysql has a system database conveniently called mysql :) 090127 18:17:18 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50045, now running 50130. Please use mysql_upgrade to fix this error. I don't know how you got to where you are now, but it seems like your system database is from MySQL 5.0.45, while you seem to be running 5.1.30. couple of options: 1) try mysql_upgrade again, using root and it's password this time 2) remove the mysql dir inside /var/lib/mysql and then use mysql_install_db to recreate them properly 3) just remove mysql completely and reinstall from scratch Normally I would recommend 2, but in your case I would probably recommend 3 since you just need mysql to run amarok2 (i would recommend songbird anyway: http://www.getsongbird.com/ ;) ) and are not planning on doing anything serious with mysql. Depending on the distro you are using, it can be as simple as yum remove mysql and yum install mysql (removing /var/lib/mysql in between). Your choice though :) good luck! Walter can you try running mysql_upgrade OlinData: Professional services for MySQL Support * Consulting * Administration http://www.olindata.com On Wed, Jan 28, 2009 at 3:21 AM, JD jd1...@gmail.com wrote: OK, I located a weblog on how to change the password and it worked. I then stopped and started the serever, and this is what it belched out in the mysqld.log: 090127 18:17:16 [Note] /usr/libexec/mysqld: Normal shutdown 090127 18:17:16 InnoDB: Starting shutdown... 090127 18:17:17 InnoDB: Shutdown completed; log sequence number 0 44044 090127 18:17:17 [Note] /usr/libexec/mysqld: Shutdown complete 090127 18:17:17 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 090127 18:17:18 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql /usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist 090127 18:17:18 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 090127 18:17:18 InnoDB: Started; log sequence number 0 44044 090127 18:17:18 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 090127 18:17:18 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50045, now running 50130. Please use mysql_upgrade to fix this error. 090127 18:17:18 [ERROR] mysql.user has no `Event_priv` column at position 29 090127 18:17:18 [ERROR] Cannot open mysql.event 090127 18:17:18 [ERROR] Event Scheduler: An error occurred when
Re: Mysqld fails to start
Hey... Thanks a *LOT Walter!!!* *It WORKED!!!* The mysqld.log file now says: 090127 19:16:10 [Note] /usr/libexec/mysqld: Normal shutdown 090127 19:16:10 InnoDB: Starting shutdown... 090127 19:16:10 InnoDB: Shutdown completed; log sequence number 0 44044 090127 19:16:10 [Note] /usr/libexec/mysqld: Shutdown complete 090127 19:16:10 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 090127 19:16:11 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 090127 19:16:11 InnoDB: Started; log sequence number 0 44044 090127 19:16:11 [Note] Event Scheduler: Loaded 0 events 090127 19:16:11 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.1.30' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) by Remi Cool. Now Amarok2 cannot continue to bitch at me, but I will try Songbird. Cheers, JD Walter Heck wrote: mysql.user is a table name, it is in the form of database_name.table_name. Mysql has a system database conveniently called mysql :) 090127 18:17:18 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50045, now running 50130. Please use mysql_upgrade to fix this error. I don't know how you got to where you are now, but it seems like your system database is from MySQL 5.0.45, while you seem to be running 5.1.30. couple of options: 1) try mysql_upgrade again, using root and it's password this time 2) remove the mysql dir inside /var/lib/mysql and then use mysql_install_db to recreate them properly 3) just remove mysql completely and reinstall from scratch Normally I would recommend 2, but in your case I would probably recommend 3 since you just need mysql to run amarok2 (i would recommend songbird anyway: http://www.getsongbird.com/ ;) ) and are not planning on doing anything serious with mysql. Depending on the distro you are using, it can be as simple as yum remove mysql and yum install mysql (removing /var/lib/mysql in between). Your choice though :) good luck! Walter can you try running mysql_upgrade OlinData: Professional services for MySQL Support * Consulting * Administration http://www.olindata.com On Wed, Jan 28, 2009 at 3:21 AM, JD jd1...@gmail.com wrote: OK, I located a weblog on how to change the password and it worked. I then stopped and started the serever, and this is what it belched out in the mysqld.log: 090127 18:17:16 [Note] /usr/libexec/mysqld: Normal shutdown 090127 18:17:16 InnoDB: Starting shutdown... 090127 18:17:17 InnoDB: Shutdown completed; log sequence number 0 44044 090127 18:17:17 [Note] /usr/libexec/mysqld: Shutdown complete 090127 18:17:17 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 090127 18:17:18 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql /usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist 090127 18:17:18 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 090127 18:17:18 InnoDB: Started; log sequence number 0 44044 090127 18:17:18 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 090127 18:17:18 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50045, now running 50130. Please use mysql_upgrade to fix this error. 090127 18:17:18 [ERROR] mysql.user has no `Event_priv` column at position 29 090127 18:17:18 [ERROR] Cannot open mysql.event 090127 18:17:18 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler. 090127 18:17:18 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.1.30' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) by Remi So, how do I fix those errors about 'mysql.plugin' and mysql.db and mysql.user For that matter why does it even have a mysql.user ??? Should it not be mysql.root? Walter Heck wrote: We're slowly getting there ;) that is the root account for the mysql server, not the linux root account :) when you installed mysql, you chose a root password. If you didn't, look up how to reset your mysql root account's password. Plenty of info on the web :) good luck! Walter OlinData: Professional services for MySQL Support * Consulting * Administration http://www.olindata.com On Wed, Jan 28, 2009 at 1:47 AM, JD jd1...@gmail.com wrote: I did the chmod. Then # ls -latrR /var/lib/mysql /var/lib/mysql: total 20548K drwxrwxr-x 2 mysql mysql 4096 2007-12-15 15:36 test/ -rw-rw-r-- 1 mysql mysql 5242880 2007-12-15 15:36 ib_logfile1 drwxrwxr-x 2 mysql mysql 4096 2007-12-15 16:10 ampache/ drwxrwxr-x 2 mysql mysql 4096 2009-01-21 14:12 mysql/ drwxr-xr-x 53 root root 4096 2009-01-27 14:14 ../ srwxrwxrwx 1 mysql mysql0 2009-01-27 16:35 mysql.sock= -rw-rw-r-- 1 mysql mysql 5242880 2009-01-27 16:35 ib_logfile0 -rw-rw-r-- 1 mysql mysql 10485760 2009-01-27 16:35 ibdata1 drwxrwxr-x 5 mysql mysql 4096 2009-01-27 16:35 ./
server mysqld how to start in WindowsXP
Why can't I start mysqld server on WindowsXp, The reference manula for 5.0 says that there are three servber types.But I am able to start only on mysqld, and only mysqld-nt gets installed.Am I doing something wrong? Varuna
mysqld fails to start with error unknown option '--enable-named-pipe'
SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). SEND-PR: From: root To: mysql@lists.mysql.com Subject: MySQL daemon fails to start Description: mysqld fails with error 070827 10:52:04 [ERROR] /usr/sbin/mysqld: unknown option '--enable-named-pipe' This error happened right at install: [EMAIL PROTECTED] ~]# ls /tmp/MySQL-server-community-5.0.45-0.rhel5.i386.rpm /tmp/MySQL-server-community-5.0.45-0.rhel5.i386.rpm [EMAIL PROTECTED] ~]# rpm -i /tmp/MySQL-server-community-5.0.45-0.rhel5.i386.rpm 070827 10:52:04 [ERROR] /usr/sbin/mysqld: unknown option '--enable-named-pipe' Installation of system tables failed! Examine the logs in /var/lib/mysql for more information. You can try to start the mysqld daemon with: /usr/sbin/mysqld --skip-grant and use the command line tool /usr/bin/mysql to connect to the mysql database and look at the grant tables: shell /usr/bin/mysql -u root mysql mysql show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in /var/lib/mysql that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com Please consult the MySQL manual section: 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source is the MySQL email archive. Please check all of the above before mailing us! And if you do mail us, you MUST use the /usr/bin/mysqlbug script! Starting MySQL ERROR! Couldn't find MySQL manager or server Giving mysqld 2 seconds to start How-To-Repeat: code/input/activities to reproduce the problem (multiple lines) Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: [EMAIL PROTECTED] Originator:root Organization: Credics Technologies MySQL support: [none] Synopsis: mysqld fails to start Severity: critical Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-5.0.45-community (MySQL Community Edition (GPL)) C compiler:gcc (GCC) 4.1.1 20070105 (Red Hat 4.1.1-52) C++ compiler: gcc (GCC) 4.1.1 20070105 (Red Hat 4.1.1-52) Environment: machine, os, target, libraries (multiple lines) System: Linux localhost.localdomain 2.6.22.2-42.fc6 #1 SMP Wed Aug 15 12:34:26 EDT 2007 i686 i686 i386 GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Using built-in specs. Target: i386-redhat-linux Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --enable-checking=release --with-system-zlib --enable-__cxa_atexit --disable-libunwind-exceptions --enable-libgcj-multifile --enable-languages=c,c++,objc,obj-c++,java,fortran,ada --enable-java-awt=gtk --disable-dssi --enable-plugin --with-java-home=/usr/lib/jvm/java-1.4.2-gcj-1.4.2.0/jre --with-cpu=generic --host=i386-redhat-linux Thread model: posix gcc version 4.1.2 20070626 (Red Hat 4.1.2-13) Compilation info: CC='gcc' CFLAGS='-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic -fasynchronous-unwind-tables' CXX='gcc' CXXFLAGS='-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic -fasynchronous-unwind-tables' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx 1 root root 11 Aug 7 11:09 /lib/libc.so.6 - libc-2.5.so -rwxr-xr-x 1 root root 1589908 Jul 5 00:48 /lib/libc-2.5.so -rw-r--r-- 1 root root 2789028 Jul 5 00:29 /usr/lib/libc.a -rw-r--r-- 1 root root 238 Jul 5 00:10 /usr/lib/libc.so Configure command: ./configure '--disable-shared' '--with-server-suffix=-community' '--without-embedded-server' '--with-ndbcluster' '--with-innodb' '--with-csv-storage-engine' '--with-archive-storage-engine' '--with-blackhole-storage-engine' '--with-example-storage-engine' '--with-federated-storage-engine' '--without-bench' '--with-zlib-dir=bundled' '--with-big-tables' '--enable-assembler' '--enable-local-infile' '--with-mysqld-user=mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--with-pic' '--prefix=/' '--with-extra-charsets=all' '--with-yassl' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--libdir=/usr/lib' '--sysconfdir=/etc' '--datadir=/usr/share' '--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info' '--includedir=/usr/include' '--mandir=/usr/share/man' '--enable-thread-safe-client' '--with-comment=MySQL Community Edition (GPL)' '--with-readline' 'CC=gcc' 'CFLAGS=-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic -fasynchronous-unwind-tables' 'CXXFLAGS=-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2
Error message when I run mysqld command to start the server
Hello, I have a problem in strating the server. I get these errors, please help me in this regard error C:\Program Files\EasyPHP1-7\mysql\binmysqld Can't start server: Bind on TCP/IP port: No error 060602 15:46:50 Do you already have another mysqld server running on port: 3306 ? 060602 15:46:50 Aborting 060602 15:46:50 C:\PROGRA~1\EASYPH~1\MYSQL\BIN\MYSQLD.EXE: Got signal 11. Abort ing! 060602 15:46:50 Aborting - Waiting for the reply at the earilest.. -- Regards Swaroop.S e-Library SDM-IMD swaroops1.googlepages.com -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. # CAUTION - Disclaimer # The information contained in this email and any attachments thereto are intended for the exclusive use of the addressee(s), and may contain proprietary, confidential or privileged information, belonging to SDM-IMD and/or its associate institutions and/or its principals (SDME Trust/Society). If you are not the intended recipient, please: delete the message as well as the attachments immediately; do not disseminate, distribute, copy or use the contents for any purpose; and notify the sender immediately. The recipient acknowledges that no guarantee or any warranty is given as to completeness and accuracy of the content of the email. The recipient further acknowledges that the views contained in the email are those of the sender and may not necessarily reflect those of SDM-IMD or its principals. SDM-IMD reserves the right to monitor the content of all messages sent to or from this email address. Messages sent to or from this email address may be stored on the SDM-IMD email system. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. SDM-IMD accepts no liability for any damage caused by any virus transmitted by this email. # End of Disclaimer # -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Error message when I run mysqld command to start the server
You might have another mysql server running Stop you running server. Change the port and then try.. -Original Message- From: Swaroop.S [mailto:[EMAIL PROTECTED] Sent: Friday, June 02, 2006 3:38 PM To: mysql@lists.mysql.com Subject: Error message when I run mysqld command to start the server Hello, I have a problem in strating the server. I get these errors, please help me in this regard error C:\Program Files\EasyPHP1-7\mysql\binmysqld Can't start server: Bind on TCP/IP port: No error 060602 15:46:50 Do you already have another mysqld server running on port: 3306 ? 060602 15:46:50 Aborting 060602 15:46:50 C:\PROGRA~1\EASYPH~1\MYSQL\BIN\MYSQLD.EXE: Got signal 11. Abort ing! 060602 15:46:50 Aborting - Waiting for the reply at the earilest.. -- Regards Swaroop.S e-Library SDM-IMD swaroops1.googlepages.com -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. # CAUTION - Disclaimer # The information contained in this email and any attachments thereto are intended for the exclusive use of the addressee(s), and may contain proprietary, confidential or privileged information, belonging to SDM-IMD and/or its associate institutions and/or its principals (SDME Trust/Society). If you are not the intended recipient, please: delete the message as well as the attachments immediately; do not disseminate, distribute, copy or use the contents for any purpose; and notify the sender immediately. The recipient acknowledges that no guarantee or any warranty is given as to completeness and accuracy of the content of the email. The recipient further acknowledges that the views contained in the email are those of the sender and may not necessarily reflect those of SDM-IMD or its principals. SDM-IMD reserves the right to monitor the content of all messages sent to or from this email address. Messages sent to or from this email address may be stored on the SDM-IMD email system. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. SDM-IMD accepts no liability for any damage caused by any virus transmitted by this email. # End of Disclaimer # -- 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]
Re: MySqld wll not start on Whitebox linux
Hello. [ERROR] Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' errno: 13) perror 13 OS error code 13: Permission denied Check that mysql user has rights on mysql directory. Charles Gambrell wrote: I am running Whitebox linux 4 and have MySql 4 installed. When I run the mysqld_safe file, mysql starts then immediately stops. It does give me the message that it is starting with databases from /var/lib/mysql In the mysqld.log file I see - [ERROR] /user/libexec/mysqld: Can't fine file: './mysql/host.frm (errno: = 13) [ERROR] Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' errno: 13) The file host.frm is in the directory /var/lib/mysql/mysql/ I am logged in as root when I run mysqld_safe. I have tried it as with the same result. This is my first attempt to run mysql on a linux server and I am hopeful for a few instructions from a more experienced user. Thank you for any help. Charles -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySqld wll not start on Whitebox linux
I am running Whitebox linux 4 and have MySql 4 installed. When I run the mysqld_safe file, mysql starts then immediately stops. It does give me the message that it is starting with databases from /var/lib/mysql In the mysqld.log file I see - [ERROR] /user/libexec/mysqld: Can't fine file: './mysql/host.frm (errno: 13) [ERROR] Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' errno: 13) The file host.frm is in the directory /var/lib/mysql/mysql/ I am logged in as root when I run mysqld_safe. I have tried it as with the same result. This is my first attempt to run mysql on a linux server and I am hopeful for a few instructions from a more experienced user. Thank you for any help. Charles -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySqld wll not start on Whitebox linux
Hi Charles, Did you create the MySql system tables by running the script mysql_install_db which is located in the scripts folder? This script will create the system tables for your mysql database. After creation you can run the mysqld_safe as root Login using mysql as user root , leave the password blanc. mysql -u root -p -h localhost or point to the socket: mysql -u root -p -S /tmp/mysql.sock Be sure you have created a special user like mysql and a group mysql. Change your file permissions on your mysql installation directory; best is to change it to: root:mysql (user:group) and change the permissions on the data directory to: mysql:mysql. Hopes this small description will help you on your way to run a complete mysql database :-) Danny Charles Gambrell wrote: I am running Whitebox linux 4 and have MySql 4 installed. When I run the mysqld_safe file, mysql starts then immediately stops. It does give me the message that it is starting with databases from /var/lib/mysql In the mysqld.log file I see - [ERROR] /user/libexec/mysqld: Can't fine file: './mysql/host.frm (errno: 13) [ERROR] Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' errno: 13) The file host.frm is in the directory /var/lib/mysql/mysql/ I am logged in as root when I run mysqld_safe. I have tried it as with the same result. This is my first attempt to run mysql on a linux server and I am hopeful for a few instructions from a more experienced user. Thank you for any help. Charles -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqld error [Can't start server: can't create PID file: No such file or directory]
Make sure /var/run/mysqld exists and wrtable by mysql user snip -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqld error [Can't start server: can't create PID file: No such file or directory]
Description: 050628 17:29:14 mysqld started 050628 17:29:14 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 050628 17:29:14 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 36808. InnoDB: Doing recovery: scanned up to log sequence number 0 43655 050628 17:29:14 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 3 5 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 7 5 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed 050628 17:29:14 InnoDB: Started; log sequence number 0 43655 050628 17:29:14 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 2) 050628 17:29:14 [ERROR] Can't start server: can't create PID file: No such file or directory 050628 17:29:14 mysqld ended How-To-Repeat: [EMAIL PROTECTED] log]# cd /usr/local/mysql [EMAIL PROTECTED] mysql]# ./bin/mysqld_safe --user=mysql [EMAIL PROTECTED] mysql]# Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/run/mysqld/mysqld.pid 050628 17:53:10 mysqld ended Fix: I wish I knew #I have verified (chgrp, chown) that mysql is the owner and group of /usr/local/mysql/* [EMAIL PROTECTED] lib]# ll -d /var/lib/mysql drwx-- 4 mysql mysql 4096 Jun 28 17:53 /var/lib/mysql [EMAIL PROTECTED] mysql]# pwd /var/lib/mysql [EMAIL PROTECTED] mysql]# ll total 20532 -rw-rw 1 mysql root 2368 Jun 28 17:53 antest1.err -rw-rw 1 mysql mysql 10485760 Jun 28 14:03 ibdata1 -rw-rw 1 mysql mysql 5242880 Jun 28 17:53 ib_logfile0 -rw-rw 1 mysql mysql 5242880 Jun 28 14:03 ib_logfile1 drwx-- 2 mysql mysql 4096 Jun 28 14:00 mysql srwxrwxrwx 1 mysql mysql0 Jun 28 17:53 mysql.sock drwx-- 2 mysql mysql 4096 Jun 28 14:00 test [EMAIL PROTECTED] run]# pwd /var/run [EMAIL PROTECTED] run]# ll -d mysql drwxrwxrwx 2 mysql mysql 4096 Jun 28 16:58 mysql NOTE *** /var/run/mysql is empty. I tried creating the mysqld.pid file (with mysql as owner and group) but still get the same problem. Submitter-Id: submitter ID Originator:Ralph J. Jackson 407.381.7797x568 Organization: JHT, Inc. MySQL support: none Synopsis: mysqld refuses to continue to run. Severity: critical Priority: medium | high Category: mysql Class: support Release: mysql-3.23.58 (Source distribution) Environment: machine, os, target, libraries (multiple lines) System: Linux antest1 2.6.11-1.35_FC3 #1 Mon Jun 13 00:52:08 EDT 2005 i686 i686 i386 GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc/i386-redhat-linux/3.4.3/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --with-system-zlib --enable-__cxa_atexit --disable-libunwind-exceptions --enable-java-awt=gtk --host=i386-redhat-linux Thread model: posix gcc version 3.4.3 20050227 (Red Hat 3.4.3-22.fc3) Compilation info: CC='i386-redhat-linux-gcc' CFLAGS='-O2 -g -pipe -m32 -march=i386 -mtune=pentium4 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' CXX='i386-redhat-linux-g++' CXXFLAGS='-O2 -g -pipe -m32 -march=i386 -mtune=pentium4 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-rtti -fno-exceptions' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Jun 24 10:23 /lib/libc.so.6 - libc-2.3.5.so -rwxr-xr-x 1 root root 1505808 Apr 7 06:58 /lib/libc-2.3.5.so -rw-r--r-- 1 root root 2409956 Apr 7 06:03 /usr/lib/libc.a -rw-r--r-- 1 root root 204 Apr 7 05:29 /usr/lib/libc.so Configure command: ./configure '--build=i386-redhat-linux' '--host=i386-redhat-linux' '--target=i386-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/usr/com' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--without-readline' '--without-debug' '--enable-shared' '--with-extra-charsets=complex' '--with-bench' '--localstatedir=/var/lib/mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--with-mysqld-user=mysql' '--with-extra-charsets=all' '--with-innodb' '--enable-local-infile' '--enable-large-files=yes' '--enable-largefile=yes' '--with-berkeley-db' '--enable-thread-safe-client' 'CFLAGS=-O2 -g -pipe -m32 -march=i386 -mtune=pentium4 -D_GNU_SOURCE
Re: mysqld error [Can't start server: can't create PID file: No such file or directory]
Hello.
to file '/var/run/mysqld/mysqld.pid' (Errcode: 2)
MySQL tries to create mysqld.pid in /var/run/mysqld ('d' at the end) not
in /var/run/mysql directory.
Description:
050628 17:29:14 mysqld started
050628 17:29:14 InnoDB: Database was not shut down normally!
.
IInnoDB: Apply batch completed
050628 17:29:14 InnoDB: Started; log sequence number 0 43655
050628 17:29:14 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write
to file '/var/run/mysqld/mysqld.pid' (Errcode: 2)
050628 17:29:14 [ERROR] Can't start server: can't create PID file: No
such file or directory
050628 17:29:14 mysqld ended
How-To-Repeat:
[EMAIL PROTECTED] log]# cd /usr/local/mysql
[EMAIL PROTECTED] mysql]# ./bin/mysqld_safe --user=mysql
[EMAIL PROTECTED] mysql]# Starting mysqld daemon with databases from
/var/lib/mysql
STOPPING server from pid file /var/run/mysqld/mysqld.pid
050628 17:53:10 mysqld ended
Fix:
I wish I knew
#I have verified (chgrp, chown) that mysql is the owner and group of
/usr/local/mysql/*
[EMAIL PROTECTED] lib]# ll -d /var/lib/mysql
drwx-- 4 mysql mysql 4096 Jun 28 17:53 /var/lib/mysql
[EMAIL PROTECTED] mysql]# pwd
/var/lib/mysql
[EMAIL PROTECTED] mysql]# ll
total 20532
-rw-rw 1 mysql root 2368 Jun 28 17:53 antest1.err
-rw-rw 1 mysql mysql 10485760 Jun 28 14:03 ibdata1
-rw-rw 1 mysql mysql 5242880 Jun 28 17:53 ib_logfile0
-rw-rw 1 mysql mysql 5242880 Jun 28 14:03 ib_logfile1
drwx-- 2 mysql mysql 4096 Jun 28 14:00 mysql
srwxrwxrwx 1 mysql mysql0 Jun 28 17:53 mysql.sock
drwx-- 2 mysql mysql 4096 Jun 28 14:00 test
[EMAIL PROTECTED] run]# pwd
/var/run
[EMAIL PROTECTED] run]# ll -d mysql
drwxrwxrwx 2 mysql mysql 4096 Jun 28 16:58 mysql
NOTE ***
/var/run/mysql is empty. I tried creating the mysqld.pid
file (with mysql as owner and group) but still get the same pro
Ralph Jackson [EMAIL PROTECTED] wrote:
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysqld stop after start
Hi all, I have followed the instruction from the mysql manual installing the binary distribution. I am actually having problem starting mysqld. I have got the following message. It started but stopped straight away. rootbin/mysqld_safe [1] 30527 rootStarting mysqld daemon with databases from /usr/local/mysql/data 031023 09:50:30 mysqld ended [EMAIL PROTECTED]/usr/local/mysqlbin/mysqld_safe --user=mysql [1] 30551 [EMAIL PROTECTED]/usr/local/mysqlStarting mysqld daemon with databases from /usr/local/mysql/data 031023 09:52:22 mysqld ended I just can't start mysqld. Could anyone please tell me why? Or is there any log I can have a look what reason the mysqld stopped right after I start it. Cheers, Clive -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Mysqld stop after start
thanks paul... I have downloaded the 4.0.16 and installed. And it works find now it was 4.0.15 that I installed.. the 4.0.16 just released today... Cheers, Clive -Original Message- From: Paul Darius [mailto:[EMAIL PROTECTED] Sent: Thursday, October 23, 2003 12:32 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Mysqld stop after start Just check the permission of mysql directory. make sure it's own by mysql and group mysql. that's all Regards from Indonesia PD On 10/23/2003, Clive Luk [EMAIL PROTECTED] wrote: Hi all, I have followed the instruction from the mysql manual installing the binary distribution. I am actually having problem starting mysqld. I have got the following message. It started but stopped straight away. rootbin/mysqld_safe [1] 30527 rootStarting mysqld daemon with databases from /usr/local/mysql/data 031023 09:50:30 mysqld ended [EMAIL PROTECTED]/usr/local/mysqlbin/mysqld_safe --user=mysql [1] 30551 [EMAIL PROTECTED]/usr/local/mysqlStarting mysqld daemon with databases from /usr/local/mysql/data 031023 09:52:22 mysqld ended I just can't start mysqld. Could anyone please tell me why? Or is there any log I can have a look what reason the mysqld stopped right after I start it. Cheers, Clive -- 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]
mysqld will not start
Folks, I am trying to start mysqld and when I do the deamon crashes. mysqld.log has the following: 030919 14:25:06 mysqld started 030919 14:25:08 Can't start server : Bind on unix socket: Permission denied 030919 14:25:08 Do you already have another mysqld server running on socket: /usr/lib/mysql/mysql.sock ? 030919 14:25:08 Aborting 030919 14:25:08 /usr/libexec/mysqld: Shutdown Complete 030919 14:25:08 mysqld ended which says to me that something is already listening on that port. Acording to netstat nothing is running. Does any one know what is going on with this. Joseph Donato __ Joseph E. Donato New Brunswick Computing Services RUCS-NB Help Desk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqld will not start
Joseph Donato wrote: Folks, I am trying to start mysqld and when I do the deamon crashes. mysqld.log has the following: 030919 14:25:06 mysqld started 030919 14:25:08 Can't start server : Bind on unix socket: Permission denied 030919 14:25:08 Do you already have another mysqld server running on socket: /usr/lib/mysql/mysql.sock ? 030919 14:25:08 Aborting 030919 14:25:08 /usr/libexec/mysqld: Shutdown Complete 030919 14:25:08 mysqld ended which says to me that something is already listening on that port. Not port, socket. Acording to netstat nothing is running. Does any one know what is going on with this. This is not a network issue. Does the socket /usr/lib/mysql/mysql.sock exist? Does mysql own /usr/lib/mysql, and all its files? Is /usr/lib/mysql world searchable? Is /usr/lib/mysql/mysql.sock work writeable? Joseph Donato __ Joseph E. Donato New Brunswick Computing Services RUCS-NB Help Desk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqld ending at start up
I installed mysql 4 today and ran mysqld_safe. Here is what I get back... [EMAIL PROTECTED] admin]# Starting mysqld daemon with databases from /var/lib/mysql 030328 05:22:36 mysqld ended What is wrong? Thanks, Joe. __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqld ending at start up
What's your log say? Should be in /var/lib/mysql/hostname.err -jeff On Fri, 2003-03-28 at 18:32, Joseph Bannon wrote: I installed mysql 4 today and ran mysqld_safe. Here is what I get back... [EMAIL PROTECTED] admin]# Starting mysqld daemon with databases from /var/lib/mysql 030328 05:22:36 mysqld ended What is wrong? Thanks, Joe. __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqld ending at start up
What's your log say? Should be in /var/lib/mysql/hostname.err I don't have one. But there is a mysql.sock. J. __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqld ending at start up
I face the same problem a month ago. see your mysql database permission; it should be 750 (minimum) and belong to mysql user and group. YEAH! That did it. Thanks a million! Also, how do I move the var directory to another location? J. __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqld ending at start up
What I mean is the permission of mysql database directory and data. Seems you already solved the problem. Yeah, I figured out what you ment. issue the command 'mv /var/lib/mysql What I ment was, when I installed mysql, I set the prefix as /home/mysql, however, the var directory for mysql is not going to /home/mysql/var. It's saving everything to /var/lib/mysql. J. __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
