mysql workbench new user using windows os

$this->_connection = new mysqli('localhost', 'sandbox', 'sandbox', 'sandbox');

I am doing a tutorial
so I want to create username sandbox on localhost on mysql on windows

How to create new user on mysql.  I am using sql query editor mysql workbench
LVL 1
rgb192Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
GaryConnect With a Mentor Commented:
0
 
rgb192Author Commented:
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

please make sandbox have all privileges to all databases on localhost
0
 
rgb192Author Commented:
Thank you.
You have correct answer because the user was created.

A related question about giving user privileges:
http://www.experts-exchange.com/Database/MySQL/Q_28348740.html
0
All Courses

From novice to tech pro — start learning today.