MySQL Linux

3

MySQL Linux. Management Studio . CLI . , , (permissions) Linux .

SSH. :

mysql -u root -p

MySQL:

mysql>

, . , MySQL:

CREATE USER ''@'localhost' IDENTIFIED BY '';

, , . :

GRANT  ON _. TO ''@'localhost';

:

  1. - :
    • ALL . , , MySQL ( );
    • CREATE ;
    • DELETE ;
    • DROP (, );
    • EXECUTE ;
    • GRANT OPTION ( ) ;
    • INSERT .. , ;
    • SELECT () SQL ;
    • SHOW DATABASES - ;
    • UPDATE ;
  2. _ , , ;
  3. - . , table, le tableau;
  4. - ;

. .

1

example, :

GRANT CREATE ON *.* TO 'example'@'localhost';

(*) , .

2

example , easybro

GRANT DROP ON easybro.* TO 'example'@'localhost';

, DROP. , :

FLUSH PRIVILEGES;
MySQL

. , example:

SHOW GRANTS FOR 'example'@'localhost';

?

Telegram YoutubeTelegram

50% Merion Academy