|
Answer» Hello
I just WANTED to know how to CREATE user accounts in 'mysql COMMAND LINE client' and login with them.
I have SEEN many tutorials on the internet about this but only a few concerned with command line client.
Any help will be appreciated.
CheersThe command line client is just a frontend to the SQL server, you don't add users to the client, you just add them to the database server.
For this you would use an CREATE USER... query to create the user on the database server and then an appropriate GRANT... query to give the user sufficient access rights.
This user can then login to the SQL server through the command line client or through any other means of connecting to the database.
|
