allow user all privileges to database
I am using sql query editor mysql workbench
$this->_connection = new mysqli('localhost', 'sandbox', 'sandbox', 'sandbox');
I am doing a tutorial
so I want to allow username sandbox to database sandbox on localhost on mysql on windows
please make sandbox have all privileges to all databases on localhost
I can log on to mysql workbench as sandbox
but can not view sandbox database (created with user: root) as user: sandbox
I also tried with a php script and can not view sandbox
$this->_connection = new mysqli('localhost', 'sandbox', 'sandbox', 'sandbox');
I am doing a tutorial
so I want to allow username sandbox to database sandbox on localhost on mysql on windows
please make sandbox have all privileges to all databases on localhost
I can log on to mysql workbench as sandbox
but can not view sandbox database (created with user: root) as user: sandbox
I also tried with a php script and can not view sandbox
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
first to answer thanks
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
FLUSH PRIVILEGES;