Categories

MariaDB – Probleme de connexion à l’installation

root@docker-test:/etc/nginx/sites-enabled#

root@docker-test:/etc/nginx/sites-enabled# mysqladmin -u root password

mysqladmin: connect to server at ‘localhost’ failed

error: ‘Access denied for user ‘root’@’localhost’ (using password: NO)’

root@docker-test:/etc/nginx/sites-enabled# /etc/init.d/mysql stop

[ ok ] Stopping mysql (via systemctl): mysql.service.

root@docker-test:/etc/nginx/sites-enabled#

root@docker-test:/etc/nginx/sites-enabled#  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 MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 2

Server version: 10.0.32-MariaDB-0+deb8u1 (Debian)

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

MariaDB [mysql]> update user set password=password(‘root’) where user=”root” and host=”localhost”;

Query OK, 0 rows affected (0.00 sec)

Rows matched: 1  Changed: 0  Warnings: 0

MariaDB [mysql]> exit

Bye

root@docker-test:/etc/nginx/sites-enabled#  mysqladmin shutdown

root@docker-test:/etc/nginx/sites-enabled# /etc/init.d/mysql start

[ ok ] Starting mysql (via systemctl): mysql.service.

root@docker-test:/etc/nginx/sites-enabled# mysql -u root -p

Enter password:

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 32

Server version: 10.0.32-MariaDB-0+deb8u1 (Debian)

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

MariaDB [(none)]>

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

  

  

  

This site uses Akismet to reduce spam. Learn how your comment data is processed.