Galère à n'en plus finir avec l'accès à mysql
Résolu
pristella
Messages postés
859
Date d'inscription
Statut
Contributeur
Dernière intervention
-
Toufoutoufou -
Toufoutoufou -
A voir également:
- Enter password: error 1045 (28000): access denied for user 'root'@'localhost' (using password: yes)
- Error 1045 (28000): access denied for user 'root'@'localhost' (using password: y es) - Meilleures réponses
- Error 1045 mysql 28000 access denied for user 'root'@'localhost' - Meilleures réponses
- Je n'ai plus acces a ma boite mail gmail - Guide
- Acces rapide - Guide
- Tu dois avoir accès au live pour passer live en tant qu'invité - Forum TikTok
- Chaque fichier en ligne sur le web a un chemin d’accès sur un serveur. c’est le cas du fichier du logo présent sur la page de cette ville. quel est le chemin de ce fichier à partir de la racine du site ? - Forum Graphisme
- Accès refusé - Guide
10 réponses
Essaie ça :
# /etc/init.d/mysql stoplami20j
Shutting down MySQL..
# mysqld_safe --skip-grant-tables --skip-networking &
[1] 4983
# Starting mysqld daemon with databases from /var/lib/mysql
# mysql mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.21-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> update user set password=password('aaaaaaaa') where user="root" and host="localhost";
Query OK, 0 rows affected (0,00 sec)
Rows matched: 1 Changed: 0 Warnings: 0
mysql> exit
Bye
# mysqladmin shutdown
STOPPING server from pid file /var/lib/mysql/debian.pid
030811 14:38:40 mysqld ended
[1]+ Done /usr/local/mysql/bin/mysqld_safe --skip-grant-tables --skip-networking
# /etc/init.d/mysql start
Starting MySQL
# mysql -u root -p
acer@PC-acer-ubuntu:~$ sudo -s Password: root@PC-acer-ubuntu:~# /etc/init.d/mysql stop * Stopping MySQL database server mysqld [ ok ] root@PC-acer-ubuntu:~# mysqld_safe --skip-grant-tables --skip-networking & [1] 15279 root@PC-acer-ubuntu:~# Starting mysqld daemon with databases from /var/lib/mysql mysqld_safe[15343]: started root@PC-acer-ubuntu:~# 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 1 to server version: 5.0.24a-Debian_9-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> update user set password=password('yelena03') where user="root" and host="localhost"; Query OK, 1 row affected (0.06 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> exit Bye root@PC-acer-ubuntu:~# mysqladmin shutdown STOPPING server from pid file /var/run/mysqld/mysqld.pid mysqld_safe[15404]: ended [1]+ Done mysqld_safe --skip-grant-tables --skip-networking root@PC-acer-ubuntu:~# /etc/init.d/mysql start * Starting MySQL database server mysqld [ ok ] * Checking for corrupt, not cleanly closed and upgrade needing tables. root@PC-acer-ubuntu:~# mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) root@PC-acer-ubuntu:~# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 to server version: 5.0.24a-Debian_9-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql>"acces denied" correspond à un mot de passe vide ensuite j'ai refait la commande en mettant le mot de passe 'aaaaa' (pas "a" mais un mot de passe à moi et là ça marche.
Je vais essayer maintenant de reinstaller mythtv ...