User Tools

Site Tools


divers-create-mysql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
divers-create-mysql [2022/03/23 14:46] – created 82.65.196.74divers-create-mysql [2023/09/28 12:26] (current) – external edit 127.0.0.1
Line 3: Line 3:
 CREATE DATABASE mydatabase CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; CREATE DATABASE mydatabase CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
 CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password'; CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
-GRANT ALL PRIVILEGES ON *.database TO 'newuser'@'localhost';+GRANT ALL PRIVILEGES ON database.* TO 'newuser'@'localhost';
  
  
divers-create-mysql.1648046794.txt.gz · Last modified: 2023/09/28 12:26 (external edit) · Currently locked by: 216.73.217.114