my_sql

Différences

Ci-dessous, les différences entre deux révisions de la page.

Lien vers cette vue comparative

Prochaine révision		 Révision précédente
my_sql [2018/05/16 17:08] – modification externe 127.0.0.1my_sql [2023/05/08 01:41] (Version actuelle) – modification externe 127.0.0.1
Ligne 1: Ligne 1:
-===création user + base====+====phpyadmin debian / ubuntu==== 
 +''apt install mariadb-server 
 +mysql_secure_install'' 
 +puis 
 +''apt install phpmyadmin'' 
 + 
 + 
 + 
 +====créer un compte admin==== 
 +''CREATE USER admin@localhost IDENTIFIED BY 'password'; 
 +GRANT ALL PRIVILEGES ON *.* TO admin@localhost WITH GRANT OPTION; 
 +FLUSH PRIVILEGES;'' 
 +\\  
 + 
 +====création user + base====
 ''CREATE DATABASE username; ''CREATE DATABASE username;
-\\ +
 CREATE USER 'username'@'localhost' IDENTIFIED BY 'password'; CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
 GRANT ALL PRIVILEGES ON username.* TO 'username'@'localhost' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON username.* TO 'username'@'localhost' WITH GRANT OPTION;
-\\ +
 CREATE USER 'username'@'%' IDENTIFIED BY 'password'; CREATE USER 'username'@'%' IDENTIFIED BY 'password';
-GRANT ALL PRIVILEGES ON username.* TO 'username'@'%' WITH GRANT OPTION;''+GRANT ALL PRIVILEGES ON username.* TO 'username'@'%' WITH GRANT OPTION; 
 + 
 +FLUSH PRIVILEGES;''
 \\  \\ 
  
  • my_sql.1526483302.txt.gz
  • Dernière modification: 2023/05/08 01:41
  • (modification externe)