login as : #> mysql mysql -Uroot -p then issue a command at the mysql prompt
grant all on *.* to amitabh identified by "password" thats to grant all the permissions to the user "amitabh" with password="password" or for grant on a particular database grant all on databasename.* to amitabh identified by password or on a particular table grant all on databasename.tablename to amitabh identified by password or use the insert -SQL to insert into the user table of the mysql database (remember there are 14 columns for setting the various permissions and a hostname which is basically the server ip/address where u want to connect from, it is advisable for u that u give "%" as the host name this will enable u to connect from any ip/address) remember to refresh the mysql by either restarting mysql (/etc/init.d/mysql restart) or issue a refresh command at the mysql prompt flush priviledges hope this helps rgds amitabh ----- Original Message ----- From: "Anirban Biswas" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 18, 2003 8:35 PM Subject: Re: [ilug-cal] mysql > Hi , > Or you can use mysqlaccess ( which is a perl script helps you to manage > mysql) to create user & give required permission to him/her. > > Anirban Biswas. > > On Tuesday 18 Feb 2003 16:03, Goutam Baul wrote: > > go to mysql database > > select table user; > > add a record with host ( name of the mysql server ) user (username), > > password (password) > > and grant rights as the column suggests. > > At 02:03 AM 2/18/2003 -0800, you wrote: > > >how do i create an user and database in mysql, please > > >do help -- To unsubscribe, send mail to [EMAIL PROTECTED] with the body "unsubscribe ilug-cal" and an empty subject line. FAQ: http://www.ilug-cal.org/node.php?id=3
