Le Tue, 14 Jun 2016 17:05:26 +0200, Bernard Schoenacker <[email protected]> a écrit :
> Le Tue, 14 Jun 2016 16:25:52 +0200, > Bernard Schoenacker <[email protected]> a écrit : > > > bonjour, > > > > > > j'essaye de créer un user avec mariadb en ligne de commande et voici > > le résultat : > > > > > > mysql -u phpmyadmin -p > > Enter password: > > Welcome to the MariaDB monitor. Commands end with ; or \g. > > Your MariaDB connection id is 868 > > Server version: 10.0.25-MariaDB-1 Debian buildd-unstable > > > > Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others. > > > > Type 'help;' or '\h' for help. Type '\c' to clear the current input > > statement. > > > > MariaDB [(none)]> CREATE USER 'louche'@'localhost' IDENTIFIED BY > > 'jean-michel'; ERROR 1227 (42000): Access denied; you need (at least > > one of) the CREATE USER privilege(s) for this operation > > > > > > comment sortir de l'impasse ? > > > > slt > > bernard > > > > bonjour, > > je donne la suite pour éclaircir un peut les nuages : > > For server side help, type 'help contents' > > MariaDB [(none)]> status > -------------- > mysql Ver 15.1 Distrib 10.0.25-MariaDB, for debian-linux-gnu (i686) > using readline 5.2 > > Connection id: 879 > Current database: > Current user: phpmyadmin@localhost > SSL: Not in use > Current pager: most > Using outfile: '' > Using delimiter: ; > Server: MariaDB > Server version: 10.0.25-MariaDB-1 Debian > buildd-unstable Protocol version: 10 > Connection: Localhost via UNIX socket > Server characterset: utf8mb4 > Db characterset: utf8mb4 > Client characterset: utf8mb4 > Conn. characterset: utf8mb4 > UNIX socket: /var/run/mysqld/mysqld.sock > Uptime: 3 days 16 hours 5 min 28 sec > > Threads: 1 Questions: 4746 Slow queries: 0 Opens: 34 Flush tables: > 1 Open tables: 97 Queries per second avg: 0.014 -------------- > > > slt > bernard > bonjour, j'ai essayé laprocédure debian : mysql -u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) slt bernard
