Add a user to MySQL – RCK

Proceed as pi.

MySQL server login.

sudo mysql -uroot -p[rootpassword] mysql

Add user ‘wp’ (Stepping line)

create user 'wp'@'%' identified by 'userpassword';

grant all privileges on wp.* to 'wp'@'%';

create user 'wp'@'localhost' identified by 'userpassword';
grant all privileges on wp.* to 'wp'@'localhost';

### Tip - delete user:
 drop user 'wp'@'%';
 drop user 'wp'@'localhost';
###

Create database ‘wp’

create database wp;

MySQL restart

flush privileges;

Confirmation database.

show databases;

 

Leave a Reply

Your email address will not be published. Required fields are marked *