Re: erreur pour créer un user avec mariadb
Le Tue, 14 Jun 2016 17:05:26 +0200,
Bernard Schoenacker <bernard.schoenacker@free.fr> a écrit :
> 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
>
bonjour,
j'ai essayé laprocédure debian :
mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
slt
bernard
Reply to: