|
USE mysql;
|
|
|
|
DROP USER IF EXISTS wensleydale@localhost;
|
|
|
|
CREATE USER wensleydale@localhost
|
|
IDENTIFIED BY '';
|
|
|
|
GRANT ALL PRIVILEGES ON cheese_shop.*
|
|
TO wensleydale@localhost;
|
|
|
|
UPDATE user
|
|
SET plugin='mysql_native_password'
|
|
WHERE User='wensleydale';
|
|
|
|
FLUSH PRIVILEGES;
|