iC Home > Know-how > MySQL Database > User Management
MySQL Database	4 User Management

X X

4.1	Access Restriction from root

Connect to MySQL's metabase

mysql -D mysql

mysql> SELECT Host,User,Password,Select_priv FROM user;

Create a new database user

mysql> GRANT ALL PRIVILEGES ON *.* TO '<user>'@'hostname';

Add a password

mysql> UPDATE user SET Password=PASSWORD('foo') WHERE User='apache' AND Host='hostname';

mysql> FLUSH PRIVILEGES;

Create a Read-only User

GRANT SELECT ON *.* TO 'primus'@'any.example.ch';
UPDATE user SET Password=PASSWORD('foo') WHERE User='primus' AND Host='any.example.ch';

---

See also:
dev.mysql.com/doc/mysql/en/adding-users.html↑

<- 3.2.1 Change Constraint       4.1 Access Restriction from root ->

copyright by reto - created with mytexi