mirror of https://bitbucket.org/anguist/ntpa
33 lines
964 B
Plaintext
33 lines
964 B
Plaintext
Setup MariaDB or MySQL in one line
|
|
----------------------------------
|
|
|
|
Create a database on localhost named "ntpa" and a user named "ntpau" with password "password".
|
|
|
|
# mysql -u root -p -e "CREATE DATABASE ntpa; CREATE USER 'ntpau'@'localhost' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON ntpa.* TO 'ntpau'@'localhost'; FLUSH PRIVILEGES;"
|
|
|
|
|
|
Setup a MySQL user on localhost
|
|
-------------------------------
|
|
|
|
Log in as root:
|
|
# mysql -uroot -p
|
|
|
|
Create database and grant privileges:
|
|
# CREATE DATABASE ntpa;
|
|
# CREATE USER 'ntpau'@'localhost' IDENTIFIED BY 'password';
|
|
# GRANT ALL PRIVILEGES ON ntpa . * TO 'ntpau'@'localhost';
|
|
# FLUSH PRIVILEGES;
|
|
|
|
|
|
Setup a MySQL user on a foreign host
|
|
------------------------------------
|
|
|
|
Log in as root:
|
|
# mysql -uroot -p
|
|
|
|
Create database and grant privileges:
|
|
# CREATE DATABASE ntpa;
|
|
# CREATE USER 'ntpau'@'192.168.1.1' IDENTIFIED BY 'password';
|
|
# GRANT ALL PRIVILEGES ON ntpa . * TO 'ntpau'@'192.168.1.1';
|
|
# FLUSH PRIVILEGES;
|