Day: July 15, 2010

Creating Mysql databse Users and changing Password using shell

July 15, 2010

Create a new user. INSERT INTO [table name] (Host,User,Password) VALUES(‘%’,’user’,PASSWORD(‘password’)); Change a users password.(from unix shell). mysqladmin -u root -h hostname.blah.org -p password ‘new-password’ Change a users password SET PASSWORD FOR ‘user’@’hostname’ = PASSWORD(‘passwordhere’); Allow the user “karthick” to connect to the server from localhost using the password “passwd123” grant usage on *.* to karthick@localhost […]

Read More