Re: erreur pour créer un user avec mariadb
Le Tue, 14 Jun 2016 16:25:52 +0200,
Bernard Schoenacker <bernard.schoenacker@free.fr> 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
Reply to: