Re: Install de spip

[Arnaud CALVO <arnaud.anti-spam@calvo-france.com>]

Jean-Michel OLTRA a écrit :

> Le vendredi 05 décembre 2003, Arnaud CALVO a écrit...
> > arnaud@debian:~$ mysql
> > ERROR 2003: Can't connect to MySQL server on 'debian' (111)

> * Avec la commande ps vois tu un serveur qui tourne ?

localhost:/home/arnaud# ps ax | grep mysql
  798 ?        S      0:00 /bin/sh /usr/bin/mysqld_safe
  838 ?        S      0:00 /usr/sbin/mysqld --basedir=/usr 
--datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mys
qld/mysqld.pid --skip-locking --port=3306 
--socket=/var/run/mysqld/mysqld.sock
  839 ?        S      0:00 /usr/sbin/mysqld --basedir=/usr 
--datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mys
qld/mysqld.pid --skip-locking --port=3306 
--socket=/var/run/mysqld/mysqld.sock
  840 ?        S      0:00 /usr/sbin/mysqld --basedir=/usr 
--datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mys
qld/mysqld.pid --skip-locking --port=3306 
--socket=/var/run/mysqld/mysqld.sock
  841 ?        S      0:00 /usr/sbin/mysqld --basedir=/usr 
--datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mys
qld/mysqld.pid --skip-locking --port=3306 
--socket=/var/run/mysqld/mysqld.sock

> * As tu une socket mysql.sock quelque part avec les droits qui vont bien
>  (777) ?

localhost:/home/arnaud# ll /var/run/mysqld/mysqld.sock
srwxrwxrwx    1 mysql    mysql           0 2003-12-05 20:54 
/var/run/mysqld/mysqld.sock

Ça semble OK

> * As tu installé mysql proprement avec le lancement du script
> mysql_install_db ?

Je ne savais pas qu'il fallait le faire, au début, mais voilà :

localhost:/home/arnaud# mysql_install_db
Installing all prepared tables
031205 22:27:10  /usr/sbin/mysqld: Shutdown Complete

To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h localhost password 'new-password'
See the manual for more instructions.

NOTE:  If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &
[...]

> * Possèdes tu quelque part (je ne sais pas où le .deb le fourre) le
> dossier var/ de mysql qui possède les bases

localhost:/home/arnaud# find /var | grep -i mysql
[...]
/var/lib/mysql/mysql
/var/lib/mysql/mysql/db.frm
/var/lib/mysql/mysql/db.MYI
/var/lib/mysql/mysql/db.MYD
/var/lib/mysql/mysql/host.frm
/var/lib/mysql/mysql/host.MYI
/var/lib/mysql/mysql/host.MYD
/var/lib/mysql/mysql/user.frm
/var/lib/mysql/mysql/user.MYI
/var/lib/mysql/mysql/user.MYD
/var/lib/mysql/mysql/func.frm
/var/lib/mysql/mysql/func.MYI
/var/lib/mysql/mysql/func.MYD
/var/lib/mysql/mysql/tables_priv.frm
/var/lib/mysql/mysql/tables_priv.MYI
/var/lib/mysql/mysql/tables_priv.MYD
/var/lib/mysql/mysql/columns_priv.frm
/var/lib/mysql/mysql/columns_priv.MYI
/var/lib/mysql/mysql/columns_priv.MYD
/var/lib/mysql/test
[...]

C'est ça ?

> * Peux tu te connecter au serveur avec
> mysql mysql (ou: mysql test [il doit y avoir une base test]) ?

Si "se connecter" c'est obtenir l'invite "mysql>", alors oui :

localhost:/home/arnaud# mysql mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 4.0.16-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> \q
Bye
localhost:/home/arnaud# mysql test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 4.0.16-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> \q
Bye
localhost:/home/arnaud#

Au secours ! J'y comprends rien !

--
Arnaud