Discussion :

[fabien62]

Bonjour,

Ubuntu 10.04 LTS
Solution Lamp

J'ai suivit ce tuto à la lettre : http://doc.ubuntu-fr.org/mysql#deplacer … nees_mysql

Hormis, pour le répertoire de destination qui ne ce trouve pas dans home, mais dans mon second hdd, du style media/hdd j'ai bien sur modifier au niveau des liens symbolique, je n'es pas touché au droit de ces répertoires.

En ligne de commande, j'obtiens cette erreur après avoir taper mon mot de passe mysql :

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Au niveau du phpmyadmin :

#2002 Connexion au serveur MySQL non permise
La connexion au "controluser" tel que défini dans votre configuration a échoué.


Un problème de droit, de déplacement ?

J'ai bien sur démarrer, le serveur, de cette façon, il me répond :
sudo /etc/init.d/mysql start
Rather than invoking init scripts through /etc/init.d, use the service(8)
utility, e.g. service mysql start

Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the start(8) utility, e.g. start mysql

J'ai fait un : sudo mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

mysql-server est installé.

Je ne sais plus quoi faire.

Merci

[fabien62]

Voici mon log mysql :

100508 14:32:02 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
100508 14:32:02 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
100508 14:32:04 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...
100508 14:32:04 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
100508 14:32:06 InnoDB: Started; log sequence number 0 0
100508 14:32:06 InnoDB: Starting shutdown...
100508 14:32:08 InnoDB: Shutdown completed; log sequence number 0 44233
100508 14:32:08 [Note] Plugin 'FEDERATED' is disabled.
100508 14:32:08 InnoDB: Started; log sequence number 0 44233
100508 14:32:08 InnoDB: Starting shutdown...
100508 14:32:09 InnoDB: Shutdown completed; log sequence number 0 44233
100508 14:32:10 [Note] Plugin 'FEDERATED' is disabled.
100508 14:32:10 InnoDB: Started; log sequence number 0 44233
ERROR: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1
100508 14:32:10 [ERROR] Aborting

100508 14:32:10 InnoDB: Starting shutdown...
100508 14:32:11 InnoDB: Shutdown completed; log sequence number 0 44233
100508 14:32:11 [Note] /usr/sbin/mysqld: Shutdown complete

100508 14:32:11 [Note] Plugin 'FEDERATED' is disabled.
100508 14:32:12 InnoDB: Started; log sequence number 0 44233
100508 14:32:12 InnoDB: Starting shutdown...
100508 14:32:13 InnoDB: Shutdown completed; log sequence number 0 44233
100508 14:32:13 [Note] Plugin 'FEDERATED' is disabled.
100508 14:32:14 InnoDB: Started; log sequence number 0 44233
ERROR: 1050 Table 'plugin' already exists
100508 14:32:14 [ERROR] Aborting

100508 14:32:14 InnoDB: Starting shutdown...
100508 14:32:15 InnoDB: Shutdown completed; log sequence number 0 44233
100508 14:32:15 [Note] /usr/sbin/mysqld: Shutdown complete

100508 14:32:17 [Note] Plugin 'FEDERATED' is disabled.
100508 14:32:18 InnoDB: Started; log sequence number 0 44233
100508 14:32:18 [Note] Event Scheduler: Loaded 0 events
100508 14:32:18 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.41-3ubuntu12' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
100508 15:13:17 [Note] /usr/sbin/mysqld: Normal shutdown

100508 15:13:17 [Note] Event Scheduler: Purging the queue. 0 events
100508 15:13:17 InnoDB: Starting shutdown...
100508 15:13:18 InnoDB: Shutdown completed; log sequence number 0 44233
100508 15:13:18 [Note] /usr/sbin/mysqld: Shutdown complete

100508 15:13:19 [Note] Plugin 'FEDERATED' is disabled.
100508 15:13:20 InnoDB: Started; log sequence number 0 44233
100508 15:13:20 [Note] Event Scheduler: Loaded 0 events
100508 15:13:20 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.41-3ubuntu12' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
100508 15:21:11 [Note] /usr/sbin/mysqld: Normal shutdown

100508 15:21:11 [Note] Event Scheduler: Purging the queue. 0 events
100508 15:21:11 InnoDB: Starting shutdown...
100508 15:21:12 InnoDB: Shutdown completed; log sequence number 0 44233
100508 15:21:12 [Note] /usr/sbin/mysqld: Shutdown complete

100508 15:29:31 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
100508 15:29:31 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
100508 15:29:31 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: 'create'.
InnoDB: Cannot continue operation.
100508 17:18:00 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
100508 17:18:00 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
100508 17:18:01 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: 'create'.
InnoDB: Cannot continue operation.
100508 17:54:02 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
100508 17:54:02 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
100508 17:54:02 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: 'create'.
InnoDB: Cannot continue operation.
100508 18:22:17 [Note] Plugin 'FEDERATED' is disabled.
mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
100508 18:22:17 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
100508 18:22:17 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
100508 18:22:18 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...
100508 18:22:18 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
100508 18:22:19 InnoDB: Started; log sequence number 0 0
mysqld: Too many arguments (first extra is 'start').
Use --verbose --help to get a list of available options
100508 18:22:19 [ERROR] Aborting

100508 18:22:19 InnoDB: Starting shutdown...
100508 18:22:20 InnoDB: Shutdown completed; log sequence number 0 44233
100508 18:22:20 [Note] mysqld: Shutdown complete

100508 22:10:51 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
100508 22:10:51 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
100508 22:10:51 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: 'create'.
InnoDB: Cannot continue operation.

Merci