1 |
>>suite à une (très) mauvaise config de mysql (je me retrouve bloqué au niveau des droits, |
2 |
>>n'arrive plus à me connecter meme avec root), j'ai décidé d'enlever |
3 |
completement mysql pour |
4 |
>> repartir à 0, sur des bases saines |
5 |
|
6 |
> rm -rf /var/lib/mysql |
7 |
|
8 |
merci, c'est nickel ! |
9 |
|
10 |
par contre, pour l'install, je dois faire |
11 |
|
12 |
bash-2.05b# ebuild |
13 |
/var/db/pkg/dev-db/mysql-4.0.20-r1/mysql-4.0.20-r1.ebuild config |
14 |
* Press ENTER to create the mysql database and set proper |
15 |
* permissions on it, or Control-C to abort now... |
16 |
|
17 |
Preparing db table |
18 |
Preparing host table |
19 |
Preparing user table |
20 |
Preparing func table |
21 |
Preparing tables_priv table |
22 |
Preparing columns_priv table |
23 |
Installing all prepared tables |
24 |
|
25 |
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! |
26 |
To do so, start the server, then issue the following commands: |
27 |
/etc/init.d/mysql start (you have to start the server first!) |
28 |
/usr/bin/mysqladmin -u root -h mephisto password 'new-password' |
29 |
/usr/bin/mysqladmin -u root password 'new-password' |
30 |
|
31 |
j'essaye ces commandes, mais voia que j'ai des erreurs : |
32 |
|
33 |
bash-2.05b# /usr/bin/mysqladmin -u root -h mephisto password pass |
34 |
/usr/bin/mysqladmin: connect to server at 'mephisto' failed |
35 |
error: 'Host 'mephisto.jpnetwork' is not allowed to connect to this |
36 |
MySQL server' |
37 |
bash-2.05b# /usr/bin/mysqladmin -u root password ni=eau00 |
38 |
bash-2.05b# /usr/bin/mysqladmin -u root -h mephisto password pass |
39 |
/usr/bin/mysqladmin: connect to server at 'mephisto' failed |
40 |
error: 'Host 'mephisto.jpnetwork' is not allowed to connect to this |
41 |
MySQL server' |
42 |
|
43 |
une idée ? |
44 |
|
45 |
-- |
46 |
Jean-Philippe Caruana |
47 |
http://enstimac.fr/~caruana/ |
48 |
|
49 |
-- |
50 |
gentoo-user-fr@g.o mailing list |