MySQL: Tworzenie bazy z konsoli


DROP DATABASE IF EXISTS mydb;
CREATE DATABASE mydb CHARACTER SET utf8 COLLATE utf8_bin;
CREATE USER ‘myuser’@'%’ IDENTIFIED BY ‘****’;
CREATE USER ‘myuser’@'localhost’ IDENTIFIED BY ‘****’;
GRANT ALL ON mydb.* TO ‘myuser’@'%’ WITH GRANT OPTION;
GRANT ALL ON mydb.* TO ‘myuser’@'localhost’ WITH GRANT OPTION;
FLUSH PRIVILEGES;

This entry was posted in MySQL and tagged . Bookmark the permalink. Post a comment or leave a trackback: Trackback URL.

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre lang="" line="" escaped="">