Citation
Cyrille
Bonjour,
Pour une install de mysql
Tu installes le paquet mysql (compris dans la
slack 10.0)
Puis du compte root tu te loggues sous le user
musql
# su mysql
$
là tu installes les tables de prvilèges
$ mysql_install_db
ensuite tu lances le demon mysql
en root :
chmod +x /etc/rc.d/rc.mysqld
et l'execute /etc/rc.d/rc.mysqld
(si tu veux modifier l'emplacement des tables,
edites le rc.mysqld et modifies la ligne
/usr/bin/mysqld_safe --datadir=/www/mysql
en focntion de tes besoins
Pour voir si ça tourne dans une console :
$ mysqlshow
doit te retourner une table test et mysql...
Voilà
Normalement ta base est initialisée
Reste plus qu'à installer phpmyadmin
Espere avoir repondu à ta question (j'ai lu qu'en
biais la discussion, sinon désolé)
Bon courage
++
Cyrille
J'ai exactement le meme probleme sous ma mandrake !
par contre la solution que tu donne ne marche pas !
$ su mysql
$ mysql_install_db
Installing all prepared tables
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.
key_buffer_size=8388600
read_buffer_size=131072
max_used_connections=0
max_connections=100
threads_connected=1
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 225791 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
thd=0x8572c30
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Cannot determine thread, fp=0xb73c94dc, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x8163173
0xffffe420
0x85549c0
0x818c3b5
0x817e02f
0x81804da
0xb7e763dd
0xb7ccfd9e
New value of fp=(nil) failed sanity check, terminating stack trace!
Please read [dev.mysql.com] and follow instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x8586678 = CREATE TABLE db ( Host char(60) binary DEFAULT '' NOT NULL, Db char(64) binary DEFAULT '' NOT NULL, User char(16) binary DEFAULT '' NOT NULL, Select_priv enum('N','Y') DEFAULT 'N' NOT NULL, Insert_priv enum('N','Y') DEFAULT 'N' NOT NULL, Update_priv enum('N','Y') DEFAULT 'N' NOT NULL, Delete_priv enum('N','Y') DEFAULT 'N' NOT NULL, Create_priv enum('N','Y') DEFAULT 'N' NOT NULL, Drop_priv enum('N','Y') DEFAULT 'N' NOT NULL, Grant_priv enum('N','Y') DEFAULT 'N' NOT NULL, References_priv enum('N','Y') DEFAULT 'N' NOT NULL, Index_priv enum('N','Y') DEFAULT 'N' NOT NULL, Alter_priv enum('N','Y') DEFAULT 'N' NOT NULL, Create_tmp_table_priv enum('N','Y') DEFAULT 'N' NOT NULL, Lock_tables_priv enum('N','Y') DEFAULT 'N' NOT NULL, Create_view_priv enum('N','Y') DEFAULT 'N' NOT NULL, Show_view_priv enum('N','Y') DEFAULT 'N' NOT NULL, PRIMARY KEY Host (Host,Db,User), KEY User (User) ) engine=MyISAM CHARACTER SET utf8 COLLATE utf8_bin comment='Database privileges'
thd->thread_id=1
The manual page at [www.mysql.com] contains
information that should help you find out what is causing the crash.
/usr/bin/mysql_create_system_tables: line 722: 6052 Broken pipe cat <<END_OF_DATA
use mysql;
$c_d
$i_d
$c_h
$i_h
$c_u
$i_u
$c_f
$i_f
$c_t
$c_c
$c_ht
$c_hc
$c_hr
$c_hk
$c_tzn
$i_tzn
$c_tz
$i_tz
$c_tzt
$i_tzt
$c_tztt
$i_tztt
$c_tzls
$i_tzls
$c_p
END_OF_DATA
Installation of system tables failed!
Examine the logs in /var/lib/mysql for more information.
You can also try to start the mysqld daemon with:
/usr/sbin/mysqld --skip-grant &
You can 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
[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!
-------------------------------------------------------------------------------------------------
Linux est pour la firme de Redmond ce qu'est James Bond pour les
méchants dans les films : le dernier obstacle avant la domination mondiale.