LinuxQuestions.org
Latest LQ Deal: Latest LQ Deals
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware
User Name
Password
Slackware This Forum is for the discussion of Slackware Linux.

Notices


Reply
  Search this Thread
Old 07-16-2010, 04:54 PM   #1
GNUer
LQ Newbie
 
Registered: Oct 2009
Location: Egypt
Distribution: Kubuntu
Posts: 5

Rep: Reputation: 0
MySQL Error


Hello , I'm new to slackware , so, sorry if my Question looks dumb

so I'm trying to get MySQL work , when i run
Code:
root@ahmed:/home/ahmed# /etc/rc.d/rc.mysqld restart
root@ahmed:/home/ahmed# 100717 00:36:28 mysqld_safe Logging to '/var/lib/mysql/ahmed.err'.
100717 00:36:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
then the cursor stops and get out whn i press enter or CTRL+C

then the error log !


Code:
root@ahmed:~# cat /var/lib/mysql/ahmed.err 
100716 16:23:41 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
100716 16:23:42 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
100716 16:23:43  InnoDB: Started; log sequence number 0 44233
100716 16:23:43 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
100716 16:23:43 mysqld_safe mysqld from pid file /var/run/mysql/mysql.pid ended
100716 22:57:31 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
100716 22:57:32 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
100716 22:57:33  InnoDB: Started; log sequence number 0 44233
100716 22:57:33 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
100716 22:57:33 mysqld_safe mysqld from pid file /var/run/mysql/mysql.pid ended
100716 22:59:39 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100716 22:59:39 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
100716 22:59:39  InnoDB: Started; log sequence number 0 44233
100716 22:59:39 [Note] Event Scheduler: Loaded 0 events
100716 22:59:39 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.46'  socket: '/var/run/mysql/mysql.sock'  port: 3306  Source distribution
100716 23:00:50 [Note] /usr/libexec/mysqld: Normal shutdown

100716 23:00:50 [Note] Event Scheduler: Purging the queue. 0 events
100716 23:00:50  InnoDB: Starting shutdown...
100716 23:00:55  InnoDB: Shutdown completed; log sequence number 0 44233
100716 23:00:55 [Note] /usr/libexec/mysqld: Shutdown complete

100716 23:00:55 mysqld_safe mysqld from pid file /var/run/mysql/mysql.pid ended
100716 23:00:56 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql                                
100716 23:00:56 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
100716 23:00:56  InnoDB: Started; log sequence number 0 44233
100716 23:00:56 [Note] Event Scheduler: Loaded 0 events
100716 23:00:56 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.46'  socket: '/var/run/mysql/mysql.sock'  port: 3306  Source distribution
100716 23:07:25 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100716 23:07:25 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
100716 23:07:25 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
100716 23:07:25  InnoDB: Retrying to lock the first data file
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
100716 23:09:05  InnoDB: Unable to open the first data file
InnoDB: Error in opening ./ibdata1
100716 23:09:05  InnoDB: Operating system error number 11 in a file operation.
InnoDB: Error number 11 means 'Resource temporarily unavailable'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/operating-system-error-codes.html
InnoDB: Could not open or create data files.
InnoDB: If you tried to add new data files, and it failed here,
InnoDB: you should now edit innodb_data_file_path in my.cnf back
InnoDB: to what it was, and remove the new ibdata files InnoDB created
InnoDB: in this failed attempt. InnoDB only wrote those files full of
InnoDB: zeros, but did not yet use them in any way. But be careful: do not
InnoDB: remove old data files which contain your precious data!
100716 23:09:05 [ERROR] Plugin 'InnoDB' init function returned error.
100716 23:09:05 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100716 23:09:05 [Note] Event Scheduler: Loaded 0 events
100716 23:09:05 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.46'  socket: '/var/run/mysql/mysql.sock'  port: 3306  Source distribution
100716 23:09:19 [Note] /usr/libexec/mysqld: Normal shutdown

100716 23:09:19 [Note] Event Scheduler: Purging the queue. 0 events
100716 23:09:19  InnoDB: Starting shutdown...
100716 23:09:19 [Note] /usr/libexec/mysqld: Normal shutdown

100716 23:09:19 [Note] Event Scheduler: Purging the queue. 0 events
100716 23:09:19 [Note] /usr/libexec/mysqld: Shutdown complete

100716 23:09:19 mysqld_safe mysqld from pid file /var/lib/mysql/ahmed.pid ended
100716 23:09:22  InnoDB: Shutdown completed; log sequence number 0 44233
100716 23:09:22 [Note] /usr/libexec/mysqld: Shutdown complete

100716 23:09:22 mysqld_safe mysqld from pid file /var/run/mysql/mysql.pid ended
100716 23:09:23 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100716 23:09:23 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
100716 23:09:23  InnoDB: Started; log sequence number 0 44233
100716 23:09:23 [Note] Event Scheduler: Loaded 0 events
100716 23:09:23 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.46'  socket: '/var/run/mysql/mysql.sock'  port: 3306  Source distribution
100717 00:36:19 mysqld_safe A mysqld process already exists
100717  0:36:26 [Note] /usr/libexec/mysqld: Normal shutdown

100717  0:36:26 [Note] Event Scheduler: Purging the queue. 0 events
100717  0:36:26  InnoDB: Starting shutdown...
100717  0:36:28  InnoDB: Shutdown completed; log sequence number 0 44233
100717  0:36:28 [Note] /usr/libexec/mysqld: Shutdown complete

100717 00:36:28 mysqld_safe mysqld from pid file /var/run/mysql/mysql.pid ended
100717 00:36:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100717  0:36:28 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
100717  0:36:28  InnoDB: Started; log sequence number 0 44233
100717  0:36:28 [Note] Event Scheduler: Loaded 0 events
100717  0:36:28 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.46'  socket: '/var/run/mysql/mysql.sock'  port: 3306  Source distribution
root@ahmed :~#

then as the first lines says i run mysql_upgrade

Code:
root@ahmed:~# mysql_upgrade --force
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysql/mysql.sock' 
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysql/mysql.sock' 
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.general_log
Error    : You can't use locks with log tables.
status   : OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.ndb_binlog_index                             OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.servers                                      OK
mysql.slow_log
Error    : You can't use locks with log tables.
status   : OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
Running 'mysql_fix_privilege_tables'...
OK
when i try to start mysql again i get the same message at the beginning !

what should i do now ??

btw sorry for my English

Last edited by GNUer; 07-16-2010 at 05:15 PM.
 
Old 07-16-2010, 06:56 PM   #2
paulsm4
LQ Guru
 
Registered: Mar 2004
Distribution: SusE 8.2
Posts: 5,863
Blog Entries: 1

Rep: Reputation: Disabled
Hi -

Strong suggestion: uninstall, then reinstall MySQL.

This link might be useful:
http://www.basicconfig.com/linuxserv...ysql_slackware

'Hope that helps .. PSM
 
1 members found this post helpful.
Old 07-16-2010, 07:32 PM   #3
GNUer
LQ Newbie
 
Registered: Oct 2009
Location: Egypt
Distribution: Kubuntu
Posts: 5

Original Poster
Rep: Reputation: 0
Quote:
Originally Posted by paulsm4 View Post
Hi -

Strong suggestion: uninstall, then reinstall MySQL.

This link might be useful:
http://www.basicconfig.com/linuxserv...ysql_slackware

'Hope that helps .. PSM

well i thought about this but it looks like the only way !


Code:
root@ahmed:~# removepkg mysql

Removing package /var/log/packages/mysql-5.1.46-x86_64-2...
Removing files:
  --> Deleting symlink /usr/lib64/libmysqlclient.so
  --> Deleting symlink /usr/lib64/libmysqlclient.so.16
  --> Deleting symlink /usr/lib64/libmysqlclient_r.so
  --> Deleting symlink /usr/lib64/libmysqlclient_r.so.16
  --> Deleting symlink /usr/lib64/mysql/libmysqlclient.so
  --> Deleting symlink /usr/lib64/mysql/libmysqlclient.so.16
  --> Deleting symlink /usr/lib64/mysql/libmysqlclient_r.so
  --> Deleting symlink /usr/lib64/mysql/libmysqlclient_r.so.16
  --> Deleting symlink /usr/lib64/mysql/plugin/ha_archive.so
  --> Deleting symlink /usr/lib64/mysql/plugin/ha_archive.so.0
  --> Deleting symlink /usr/lib64/mysql/plugin/ha_blackhole.so
  --> Deleting symlink /usr/lib64/mysql/plugin/ha_blackhole.so.0
  --> Deleting symlink /usr/lib64/mysql/plugin/ha_example.so
  --> Deleting symlink /usr/lib64/mysql/plugin/ha_example.so.0
  --> Deleting symlink /usr/lib64/mysql/plugin/ha_federated.so
  --> Deleting symlink /usr/lib64/mysql/plugin/ha_federated.so.0
  --> Deleting symlink /usr/lib64/mysql/plugin/ha_innodb_plugin.so
  --> Deleting symlink /usr/lib64/mysql/plugin/ha_innodb_plugin.so.0
  --> Deleting symlink /usr/lib64/mysql/plugin/libdaemon_example.so
  --> Deleting symlink /usr/lib64/mysql/plugin/libdaemon_example.so.0
  --> Deleting symlink /usr/lib64/mysql/plugin/mypluglib.so
  --> Deleting symlink /usr/lib64/mysql/plugin/mypluglib.so.0                                            
  --> Deleting /etc/my-huge.cnf
  --> Deleting /etc/my-large.cnf
  --> Deleting /etc/my-medium.cnf
  --> Deleting /etc/my-small.cnf
  --> /etc/rc.d/rc.mysqld.new no longer exists. Skipping.
  --> Deleting /usr/bin/innochecksum
  --> Deleting /usr/bin/msql2mysql
  --> Deleting /usr/bin/my_print_defaults
  --> Deleting /usr/bin/myisam_ftdump
  --> Deleting /usr/bin/myisamchk
  --> Deleting /usr/bin/myisamlog
  --> Deleting /usr/bin/myisampack
  --> Deleting /usr/bin/mysql
  --> Deleting /usr/bin/mysql_client_test
  --> Deleting /usr/bin/mysql_config
  --> Deleting /usr/bin/mysql_convert_table_format
  --> Deleting /usr/bin/mysql_find_rows
  --> Deleting /usr/bin/mysql_fix_extensions
  --> Deleting /usr/bin/mysql_fix_privilege_tables
  --> Deleting /usr/bin/mysql_install_db
  --> Deleting /usr/bin/mysql_secure_installation
  --> Deleting /usr/bin/mysql_setpermission
  --> Deleting /usr/bin/mysql_tzinfo_to_sql
  --> Deleting /usr/bin/mysql_upgrade
  --> Deleting /usr/bin/mysql_waitpid
  --> Deleting /usr/bin/mysql_zap
  --> Deleting /usr/bin/mysqlaccess
  --> Deleting /usr/bin/mysqladmin
  --> Deleting /usr/bin/mysqlbinlog
  --> Deleting /usr/bin/mysqlbug
  --> Deleting /usr/bin/mysqlcheck
  --> Deleting /usr/bin/mysqld_multi
  --> Deleting /usr/bin/mysqld_safe
  --> Deleting /usr/bin/mysqldump
  --> Deleting /usr/bin/mysqldumpslow
  --> Deleting /usr/bin/mysqlhotcopy
  --> Deleting /usr/bin/mysqlimport
  --> Deleting /usr/bin/mysqlshow
  --> Deleting /usr/bin/mysqlslap
  --> Deleting /usr/bin/mysqltest
  --> Deleting /usr/bin/perror
  --> Deleting /usr/bin/replace
  --> Deleting /usr/bin/resolve_stack_dump
  --> Deleting /usr/bin/resolveip
  --> Deleting /usr/doc/mysql-5.1.46/COPYING
  --> Deleting /usr/doc/mysql-5.1.46/ChangeLog
  --> Deleting /usr/doc/mysql-5.1.46/Docs/INSTALL-BINARY
  --> Deleting /usr/doc/mysql-5.1.46/EXCEPTIONS-CLIENT
  --> Deleting /usr/doc/mysql-5.1.46/INSTALL-SOURCE
  --> Deleting /usr/doc/mysql-5.1.46/README
  --> Deleting /usr/include/mysql/atomic/gcc_builtins.h
  --> Deleting /usr/include/mysql/atomic/nolock.h
  --> Deleting /usr/include/mysql/atomic/rwlock.h
  --> Deleting /usr/include/mysql/atomic/x86-gcc.h
  --> Deleting /usr/include/mysql/atomic/x86-msvc.h
  --> Deleting /usr/include/mysql/authors.h
  --> Deleting /usr/include/mysql/base64.h
  --> Deleting /usr/include/mysql/cclass.h
  --> Deleting /usr/include/mysql/client_settings.h
  --> Deleting /usr/include/mysql/cname.h
  --> Deleting /usr/include/mysql/config-netware.h
  --> Deleting /usr/include/mysql/config-win.h
  --> Deleting /usr/include/mysql/config.h
  --> Deleting /usr/include/mysql/contributors.h
  --> Deleting /usr/include/mysql/debug_sync.h
  --> Deleting /usr/include/mysql/decimal.h
  --> Deleting /usr/include/mysql/errmsg.h
  --> Deleting /usr/include/mysql/event_data_objects.h
  --> Deleting /usr/include/mysql/event_db_repository.h
  --> Deleting /usr/include/mysql/event_parse_data.h
  --> Deleting /usr/include/mysql/event_queue.h
  --> Deleting /usr/include/mysql/event_scheduler.h
  --> Deleting /usr/include/mysql/events.h
  --> Deleting /usr/include/mysql/field.h
  --> Deleting /usr/include/mysql/ft_global.h
  --> Deleting /usr/include/mysql/gstream.h
  --> Deleting /usr/include/mysql/ha_ndbcluster.h
  --> Deleting /usr/include/mysql/ha_ndbcluster_binlog.h
  --> Deleting /usr/include/mysql/ha_ndbcluster_cond.h
  --> Deleting /usr/include/mysql/ha_ndbcluster_tables.h
  --> Deleting /usr/include/mysql/ha_partition.h
  --> Deleting /usr/include/mysql/handler.h
  --> Deleting /usr/include/mysql/hash.h
  --> Deleting /usr/include/mysql/hash_filo.h
  --> Deleting /usr/include/mysql/heap.h
  --> Deleting /usr/include/mysql/help_end.h
  --> Deleting /usr/include/mysql/help_start.h
  --> Deleting /usr/include/mysql/item.h
  --> Deleting /usr/include/mysql/item_cmpfunc.h
  --> Deleting /usr/include/mysql/item_create.h
  --> Deleting /usr/include/mysql/item_func.h
  --> Deleting /usr/include/mysql/item_geofunc.h
  --> Deleting /usr/include/mysql/item_row.h
  --> Deleting /usr/include/mysql/item_strfunc.h
  --> Deleting /usr/include/mysql/item_subselect.h
  --> Deleting /usr/include/mysql/item_sum.h
  --> Deleting /usr/include/mysql/item_timefunc.h
  --> Deleting /usr/include/mysql/item_xmlfunc.h
  --> Deleting /usr/include/mysql/keycache.h
  --> Deleting /usr/include/mysql/lex.h
  --> Deleting /usr/include/mysql/lex_hash.h
  --> Deleting /usr/include/mysql/lex_symbol.h
  --> Deleting /usr/include/mysql/log.h
  --> Deleting /usr/include/mysql/log_event.h
  --> Deleting /usr/include/mysql/log_event_old.h
  --> Deleting /usr/include/mysql/m_ctype.h
  --> Deleting /usr/include/mysql/m_string.h
  --> Deleting /usr/include/mysql/message.h
  --> Deleting /usr/include/mysql/my_aes.h
  --> Deleting /usr/include/mysql/my_alarm.h
  --> Deleting /usr/include/mysql/my_alloc.h
  --> Deleting /usr/include/mysql/my_atomic.h
  --> Deleting /usr/include/mysql/my_attribute.h
  --> Deleting /usr/include/mysql/my_base.h
  --> Deleting /usr/include/mysql/my_bit.h
  --> Deleting /usr/include/mysql/my_bitmap.h
  --> Deleting /usr/include/mysql/my_config.h
  --> Deleting /usr/include/mysql/my_dbug.h
  --> Deleting /usr/include/mysql/my_decimal.h
  --> Deleting /usr/include/mysql/my_dir.h
  --> Deleting /usr/include/mysql/my_getopt.h
  --> Deleting /usr/include/mysql/my_global.h
  --> Deleting /usr/include/mysql/my_handler.h
  --> Deleting /usr/include/mysql/my_libwrap.h
  --> Deleting /usr/include/mysql/my_list.h
  --> Deleting /usr/include/mysql/my_md5.h
  --> Deleting /usr/include/mysql/my_net.h
  --> Deleting /usr/include/mysql/my_no_pthread.h
  --> Deleting /usr/include/mysql/my_nosys.h
  --> Deleting /usr/include/mysql/my_pthread.h
  --> Deleting /usr/include/mysql/my_regex.h
  --> Deleting /usr/include/mysql/my_stacktrace.h
  --> Deleting /usr/include/mysql/my_sys.h
  --> Deleting /usr/include/mysql/my_time.h
  --> Deleting /usr/include/mysql/my_tree.h
  --> Deleting /usr/include/mysql/my_trie.h
  --> Deleting /usr/include/mysql/my_uctype.h
  --> Deleting /usr/include/mysql/my_user.h
  --> Deleting /usr/include/mysql/my_vle.h
  --> Deleting /usr/include/mysql/my_xml.h
  --> Deleting /usr/include/mysql/myisam.h
  --> Deleting /usr/include/mysql/myisammrg.h
  --> Deleting /usr/include/mysql/myisampack.h
  --> Deleting /usr/include/mysql/mysql.h
  --> Deleting /usr/include/mysql/mysql_com.h
  --> Deleting /usr/include/mysql/mysql_embed.h
  --> Deleting /usr/include/mysql/mysql_priv.h
  --> Deleting /usr/include/mysql/mysql_time.h
  --> Deleting /usr/include/mysql/mysql_version.h
  --> Deleting /usr/include/mysql/mysqld_ername.h
  --> Deleting /usr/include/mysql/mysqld_error.h
  --> Deleting /usr/include/mysql/mysqld_suffix.h
  --> Deleting /usr/include/mysql/mysys_err.h
  --> Deleting /usr/include/mysql/nt_servc.h
  --> Deleting /usr/include/mysql/opt_range.h
  --> Deleting /usr/include/mysql/parse_file.h
  --> Deleting /usr/include/mysql/partition_element.h
  --> Deleting /usr/include/mysql/partition_info.h
  --> Deleting /usr/include/mysql/plugin.h
  --> Deleting /usr/include/mysql/procedure.h
  --> Deleting /usr/include/mysql/protocol.h
  --> Deleting /usr/include/mysql/queues.h
  --> Deleting /usr/include/mysql/regex2.h
  --> Deleting /usr/include/mysql/repl_failsafe.h
  --> Deleting /usr/include/mysql/rijndael.h
  --> Deleting /usr/include/mysql/rpl_constants.h
  --> Deleting /usr/include/mysql/rpl_filter.h
  --> Deleting /usr/include/mysql/rpl_injector.h
  --> Deleting /usr/include/mysql/rpl_mi.h
  --> Deleting /usr/include/mysql/rpl_record.h
  --> Deleting /usr/include/mysql/rpl_record_old.h
  --> Deleting /usr/include/mysql/rpl_reporting.h
  --> Deleting /usr/include/mysql/rpl_rli.h
  --> Deleting /usr/include/mysql/rpl_tblmap.h
  --> Deleting /usr/include/mysql/rpl_utility.h
  --> Deleting /usr/include/mysql/scheduler.h
  --> Deleting /usr/include/mysql/set_var.h
  --> Deleting /usr/include/mysql/sha1.h
  --> Deleting /usr/include/mysql/slave.h
  --> Deleting /usr/include/mysql/sp.h
  --> Deleting /usr/include/mysql/sp_cache.h
  --> Deleting /usr/include/mysql/sp_head.h
  --> Deleting /usr/include/mysql/sp_pcontext.h
  --> Deleting /usr/include/mysql/sp_rcontext.h
  --> Deleting /usr/include/mysql/spatial.h
  --> Deleting /usr/include/mysql/sql_acl.h
  --> Deleting /usr/include/mysql/sql_analyse.h
  --> Deleting /usr/include/mysql/sql_array.h
  --> Deleting /usr/include/mysql/sql_bitmap.h
  --> Deleting /usr/include/mysql/sql_cache.h
  --> Deleting /usr/include/mysql/sql_class.h
  --> Deleting /usr/include/mysql/sql_common.h
  --> Deleting /usr/include/mysql/sql_crypt.h
  --> Deleting /usr/include/mysql/sql_cursor.h
  --> Deleting /usr/include/mysql/sql_error.h
  --> Deleting /usr/include/mysql/sql_lex.h
  --> Deleting /usr/include/mysql/sql_list.h
  --> Deleting /usr/include/mysql/sql_map.h
  --> Deleting /usr/include/mysql/sql_partition.h
  --> Deleting /usr/include/mysql/sql_plugin.h
  --> Deleting /usr/include/mysql/sql_profile.h
  --> Deleting /usr/include/mysql/sql_repl.h
  --> Deleting /usr/include/mysql/sql_select.h
  --> Deleting /usr/include/mysql/sql_servers.h
  --> Deleting /usr/include/mysql/sql_show.h
  --> Deleting /usr/include/mysql/sql_sort.h
  --> Deleting /usr/include/mysql/sql_state.h
  --> Deleting /usr/include/mysql/sql_string.h
  --> Deleting /usr/include/mysql/sql_trigger.h
  --> Deleting /usr/include/mysql/sql_udf.h
  --> Deleting /usr/include/mysql/sql_view.h
  --> Deleting /usr/include/mysql/sql_yacc.h
  --> Deleting /usr/include/mysql/sslopt-case.h
  --> Deleting /usr/include/mysql/sslopt-longopts.h
  --> Deleting /usr/include/mysql/sslopt-vars.h
  --> Deleting /usr/include/mysql/structs.h
  --> Deleting /usr/include/mysql/t_ctype.h
  --> Deleting /usr/include/mysql/table.h
  --> Deleting /usr/include/mysql/thr_alarm.h
  --> Deleting /usr/include/mysql/thr_lock.h
  --> Deleting /usr/include/mysql/typelib.h
  --> Deleting /usr/include/mysql/tzfile.h
  --> Deleting /usr/include/mysql/tztime.h
  --> Deleting /usr/include/mysql/unireg.h
  --> Deleting /usr/include/mysql/utils.h
  --> Deleting /usr/include/mysql/violite.h
  --> Deleting /usr/info/mysql.info.gz
  --> Deleting /usr/lib64/mysql/libdbug.a
  --> Deleting /usr/lib64/mysql/libheap.a
  --> Deleting /usr/lib64/mysql/libmyisam.a
  --> Deleting /usr/lib64/mysql/libmyisammrg.a
  --> Deleting /usr/lib64/mysql/libmysqlclient.a
  --> Deleting /usr/lib64/mysql/libmysqlclient.la
  --> Deleting /usr/lib64/mysql/libmysqlclient.so.16.0.0
  --> Deleting /usr/lib64/mysql/libmysqlclient_r.a
  --> Deleting /usr/lib64/mysql/libmysqlclient_r.la
  --> Deleting /usr/lib64/mysql/libmysqlclient_r.so.16.0.0
  --> Deleting /usr/lib64/mysql/libmystrings.a
  --> Deleting /usr/lib64/mysql/libmysys.a
  --> Deleting /usr/lib64/mysql/libvio.a
  --> Deleting /usr/lib64/mysql/plugin/ha_archive.a
  --> Deleting /usr/lib64/mysql/plugin/ha_archive.la
  --> Deleting /usr/lib64/mysql/plugin/ha_archive.so.0.0.0
  --> Deleting /usr/lib64/mysql/plugin/ha_blackhole.a
  --> Deleting /usr/lib64/mysql/plugin/ha_blackhole.la
  --> Deleting /usr/lib64/mysql/plugin/ha_blackhole.so.0.0.0
  --> Deleting /usr/lib64/mysql/plugin/ha_example.a
  --> Deleting /usr/lib64/mysql/plugin/ha_example.la
  --> Deleting /usr/lib64/mysql/plugin/ha_example.so.0.0.0
  --> Deleting /usr/lib64/mysql/plugin/ha_federated.a
  --> Deleting /usr/lib64/mysql/plugin/ha_federated.la
  --> Deleting /usr/lib64/mysql/plugin/ha_federated.so.0.0.0
  --> Deleting /usr/lib64/mysql/plugin/ha_innodb_plugin.a
  --> Deleting /usr/lib64/mysql/plugin/ha_innodb_plugin.la
  --> Deleting /usr/lib64/mysql/plugin/ha_innodb_plugin.so.0.0.0
  --> Deleting /usr/lib64/mysql/plugin/libdaemon_example.a
  --> Deleting /usr/lib64/mysql/plugin/libdaemon_example.la
  --> Deleting /usr/lib64/mysql/plugin/libdaemon_example.so.0.0.0
  --> Deleting /usr/lib64/mysql/plugin/mypluglib.a
  --> Deleting /usr/lib64/mysql/plugin/mypluglib.la
  --> Deleting /usr/lib64/mysql/plugin/mypluglib.so.0.0.0
  --> Deleting /usr/libexec/mysqld
  --> Deleting /usr/libexec/mysqlmanager
  --> Deleting /usr/man/man1/comp_err.1.gz
  --> Deleting /usr/man/man1/innochecksum.1.gz
  --> Deleting /usr/man/man1/msql2mysql.1.gz
  --> Deleting /usr/man/man1/my_print_defaults.1.gz
  --> Deleting /usr/man/man1/myisam_ftdump.1.gz
  --> Deleting /usr/man/man1/myisamchk.1.gz
  --> Deleting /usr/man/man1/myisamlog.1.gz
  --> Deleting /usr/man/man1/myisampack.1.gz
  --> Deleting /usr/man/man1/mysql-stress-test.pl.1.gz
  --> Deleting /usr/man/man1/mysql-test-run.pl.1.gz
  --> Deleting /usr/man/man1/mysql.1.gz
  --> Deleting /usr/man/man1/mysql.server.1.gz
  --> Deleting /usr/man/man1/mysql_client_test.1.gz
  --> Deleting /usr/man/man1/mysql_config.1.gz
  --> Deleting /usr/man/man1/mysql_convert_table_format.1.gz
  --> Deleting /usr/man/man1/mysql_find_rows.1.gz
  --> Deleting /usr/man/man1/mysql_fix_extensions.1.gz
  --> Deleting /usr/man/man1/mysql_fix_privilege_tables.1.gz
  --> Deleting /usr/man/man1/mysql_install_db.1.gz
  --> Deleting /usr/man/man1/mysql_secure_installation.1.gz
  --> Deleting /usr/man/man1/mysql_setpermission.1.gz
  --> Deleting /usr/man/man1/mysql_tzinfo_to_sql.1.gz
  --> Deleting /usr/man/man1/mysql_upgrade.1.gz
  --> Deleting /usr/man/man1/mysql_waitpid.1.gz
  --> Deleting /usr/man/man1/mysql_zap.1.gz
  --> Deleting /usr/man/man1/mysqlaccess.1.gz
  --> Deleting /usr/man/man1/mysqladmin.1.gz
  --> Deleting /usr/man/man1/mysqlbinlog.1.gz
  --> Deleting /usr/man/man1/mysqlbug.1.gz
  --> Deleting /usr/man/man1/mysqlcheck.1.gz
  --> Deleting /usr/man/man1/mysqld_multi.1.gz
  --> Deleting /usr/man/man1/mysqld_safe.1.gz
  --> Deleting /usr/man/man1/mysqldump.1.gz
  --> Deleting /usr/man/man1/mysqldumpslow.1.gz
  --> Deleting /usr/man/man1/mysqlhotcopy.1.gz
  --> Deleting /usr/man/man1/mysqlimport.1.gz
  --> Deleting /usr/man/man1/mysqlman.1.gz
  --> Deleting /usr/man/man1/mysqlshow.1.gz
  --> Deleting /usr/man/man1/mysqlslap.1.gz
  --> Deleting /usr/man/man1/mysqltest.1.gz
  --> Deleting /usr/man/man1/perror.1.gz
  --> Deleting /usr/man/man1/replace.1.gz
  --> Deleting /usr/man/man1/resolve_stack_dump.1.gz
  --> Deleting /usr/man/man1/resolveip.1.gz
  --> Deleting /usr/man/man8/mysqld.8.gz
  --> Deleting /usr/man/man8/mysqlmanager.8.gz
  --> Deleting /usr/share/aclocal/mysql.m4
  --> Deleting /usr/share/mysql/ChangeLog
  --> Deleting /usr/share/mysql/binary-configure
  --> Deleting /usr/share/mysql/charsets/Index.xml
  --> Deleting /usr/share/mysql/charsets/README
  --> Deleting /usr/share/mysql/charsets/armscii8.xml
  --> Deleting /usr/share/mysql/charsets/ascii.xml
  --> Deleting /usr/share/mysql/charsets/cp1250.xml
  --> Deleting /usr/share/mysql/charsets/cp1251.xml
  --> Deleting /usr/share/mysql/charsets/cp1256.xml
  --> Deleting /usr/share/mysql/charsets/cp1257.xml
  --> Deleting /usr/share/mysql/charsets/cp850.xml
  --> Deleting /usr/share/mysql/charsets/cp852.xml
  --> Deleting /usr/share/mysql/charsets/cp866.xml
  --> Deleting /usr/share/mysql/charsets/dec8.xml
  --> Deleting /usr/share/mysql/charsets/geostd8.xml
  --> Deleting /usr/share/mysql/charsets/greek.xml
  --> Deleting /usr/share/mysql/charsets/hebrew.xml
  --> Deleting /usr/share/mysql/charsets/hp8.xml
  --> Deleting /usr/share/mysql/charsets/keybcs2.xml
  --> Deleting /usr/share/mysql/charsets/koi8r.xml
  --> Deleting /usr/share/mysql/charsets/koi8u.xml
  --> Deleting /usr/share/mysql/charsets/latin1.xml
  --> Deleting /usr/share/mysql/charsets/latin2.xml
  --> Deleting /usr/share/mysql/charsets/latin5.xml
  --> Deleting /usr/share/mysql/charsets/latin7.xml
  --> Deleting /usr/share/mysql/charsets/macce.xml
  --> Deleting /usr/share/mysql/charsets/macroman.xml
  --> Deleting /usr/share/mysql/charsets/swe7.xml
  --> Deleting /usr/share/mysql/config.huge.ini
  --> Deleting /usr/share/mysql/config.medium.ini
  --> Deleting /usr/share/mysql/config.small.ini
  --> Deleting /usr/share/mysql/czech/errmsg.sys
  --> Deleting /usr/share/mysql/danish/errmsg.sys
  --> Deleting /usr/share/mysql/dutch/errmsg.sys
  --> Deleting /usr/share/mysql/english/errmsg.sys
  --> Deleting /usr/share/mysql/errmsg.txt
  --> Deleting /usr/share/mysql/estonian/errmsg.sys
  --> Deleting /usr/share/mysql/fill_help_tables.sql
  --> Deleting /usr/share/mysql/french/errmsg.sys
  --> Deleting /usr/share/mysql/german/errmsg.sys
  --> Deleting /usr/share/mysql/greek/errmsg.sys
  --> Deleting /usr/share/mysql/hungarian/errmsg.sys
  --> Deleting /usr/share/mysql/italian/errmsg.sys
  --> Deleting /usr/share/mysql/japanese/errmsg.sys
  --> Deleting /usr/share/mysql/korean/errmsg.sys
  --> Deleting /usr/share/mysql/mi_test_all
  --> Deleting /usr/share/mysql/mi_test_all.res
  --> Deleting /usr/share/mysql/my-huge.cnf
  --> Deleting /usr/share/mysql/my-innodb-heavy-4G.cnf
  --> Deleting /usr/share/mysql/my-large.cnf
  --> Deleting /usr/share/mysql/my-medium.cnf
  --> Deleting /usr/share/mysql/my-small.cnf
  --> Deleting /usr/share/mysql/mysql-log-rotate
  --> Deleting /usr/share/mysql/mysql.server
  --> Deleting /usr/share/mysql/mysql_fix_privilege_tables.sql
  --> Deleting /usr/share/mysql/mysql_system_tables.sql
  --> Deleting /usr/share/mysql/mysql_system_tables_data.sql
  --> Deleting /usr/share/mysql/mysql_test_data_timezone.sql
  --> Deleting /usr/share/mysql/mysqld_multi.server
  --> Deleting /usr/share/mysql/ndb-config-2-node.ini
  --> Deleting /usr/share/mysql/norwegian-ny/errmsg.sys
  --> Deleting /usr/share/mysql/norwegian/errmsg.sys
  --> Deleting /usr/share/mysql/polish/errmsg.sys
  --> Deleting /usr/share/mysql/portuguese/errmsg.sys
  --> Deleting /usr/share/mysql/romanian/errmsg.sys
  --> Deleting /usr/share/mysql/russian/errmsg.sys
  --> Deleting /usr/share/mysql/serbian/errmsg.sys
  --> Deleting /usr/share/mysql/slovak/errmsg.sys
  --> Deleting /usr/share/mysql/spanish/errmsg.sys
  --> Deleting /usr/share/mysql/swedish/errmsg.sys
  --> Deleting /usr/share/mysql/ukrainian/errmsg.sys
WARNING: Unique directory /var/run/mysql/ contains new files
WARNING: Unique directory /var/lib/mysql/ contains new files
  --> Deleting empty directory /usr/share/mysql/ukrainian/
  --> Deleting empty directory /usr/share/mysql/swedish/
  --> Deleting empty directory /usr/share/mysql/spanish/
  --> Deleting empty directory /usr/share/mysql/slovak/
  --> Deleting empty directory /usr/share/mysql/serbian/
  --> Deleting empty directory /usr/share/mysql/russian/
  --> Deleting empty directory /usr/share/mysql/romanian/
  --> Deleting empty directory /usr/share/mysql/portuguese/
  --> Deleting empty directory /usr/share/mysql/polish/
  --> Deleting empty directory /usr/share/mysql/norwegian/
  --> Deleting empty directory /usr/share/mysql/norwegian-ny/
  --> Deleting empty directory /usr/share/mysql/korean/
  --> Deleting empty directory /usr/share/mysql/japanese/
  --> Deleting empty directory /usr/share/mysql/italian/
  --> Deleting empty directory /usr/share/mysql/hungarian/
  --> Deleting empty directory /usr/share/mysql/greek/
  --> Deleting empty directory /usr/share/mysql/german/
  --> Deleting empty directory /usr/share/mysql/french/
  --> Deleting empty directory /usr/share/mysql/estonian/
  --> Deleting empty directory /usr/share/mysql/english/
  --> Deleting empty directory /usr/share/mysql/dutch/
  --> Deleting empty directory /usr/share/mysql/danish/
  --> Deleting empty directory /usr/share/mysql/czech/
  --> Deleting empty directory /usr/share/mysql/charsets/
  --> Deleting empty directory /usr/share/mysql/
  --> Deleting empty directory /usr/lib64/mysql/plugin/
  --> Deleting empty directory /usr/lib64/mysql/
  --> Deleting empty directory /usr/include/mysql/atomic/
  --> Deleting empty directory /usr/include/mysql/
  --> Deleting empty directory /usr/doc/mysql-5.1.46/Docs/
  --> Deleting empty directory /usr/doc/mysql-5.1.46/
root@ahmed:~#
is it completely removed now ??
 
Old 07-16-2010, 07:54 PM   #4
GNUer
LQ Newbie
 
Registered: Oct 2009
Location: Egypt
Distribution: Kubuntu
Posts: 5

Original Poster
Rep: Reputation: 0
well , it works now after removing and re-installation
Code:
root@ahmed:~# mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.1.46 Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> SHOW databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
+--------------------+
2 rows in set (0.00 sec)

mysql>
thx Mr paulsm4
 
Old 08-01-2011, 12:20 PM   #5
skylined101
LQ Newbie
 
Registered: Aug 2011
Posts: 1

Rep: Reputation: Disabled
Thankx

Maybe this is not the same topic . But this solved my problem
I had problem with slave , error
Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file'
And the problem was at master >
after reinstalling mysql at master and modifing slave log position everything ok .
thanks .
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. NoviceW Linux - Networking 17 09-17-2014 02:13 PM
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. SpellChainz Linux - Software 3 06-28-2007 11:46 AM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. SpellChainz Linux - Newbie 1 06-23-2007 03:35 PM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 08:44 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware

All times are GMT -5. The time now is 12:35 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration