Subscribe: Comments on My SysAd Blog -- Unix: Create User Account Example for MySQL
http://www.mysysad.com/feeds/7710902283910012771/comments/default
Added By: Feedage Forager Feedage Grade B rated
Language: English
Tags:
clear command  command buffer  command  create user  create  esoft  grant  method  password  surf  thx surf  thx  user  variation method  variation 
Rate this Feed
Rate this feedRate this feedRate this feedRate this feedRate this feed
Rate this feed 1 starRate this feed 2 starRate this feed 3 starRate this feed 4 starRate this feed 5 star

Comments (0)

Feed Details and Statistics Feed Statistics
Preview: Comments on My SysAd Blog -- Unix: Create User Account Example for MySQL

Comments on My SysAd Blog -- Unix: Create User Account Example for MySQL





Updated: 2017-08-10T07:44:05.379-07:00

 



thx for the post! I had to surf for a while before...

2009-02-05T07:13:00.000-08:00

thx for the post!

I had to surf for a while before I found your tutorial that correctly includes the 'flush privs' command. I couldn't quite remember the syntax, but I knew there was some way to clear the command buffer.



I use a variation of method 1. When you use the GR...

2008-07-26T11:45:00.000-07:00

I use a variation of method 1. When you use the GRANT statement, it will automatically create a user if the user specified does not exist. This means you can do the following:

grant INSERT,DELETE,UPDATE,SELECT on mydb.* to esoft@localhost;

set password for esoft = password('mypasswd');