mysql-cheatsheet-reminder

Inhaltsverzeichnis

mysql: small cheatsheet / reminder
- USER
DATABASE CREATION AND USER RIGHTS
- LINKS

mysql: small cheatsheet / reminder

USER

mysql> select host, user, password from mysql.user;

DATABASE CREATION AND USER RIGHTS

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
CREATE DATABASE mynewdatabase;
GRANT ALL PRIVILEGES ON mynewdatabase . * TO 'newuser'@'localhost';
FLUSH PRIVILEGES;

LINKS

reset root password

mysql-cheatsheet-reminder.txt · Zuletzt geändert: 2015/05/20 16:26 von admin