Creating Mysql Database Users and Changing Password using Sell

Creating Mysql Database Users and Changing Password using Sell 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 passwordSET PASSWORD FOR ‘user’@’hostname’ = PASSWORD(‘passwordhere’); Allow the user “karthick” to connect to the server from localhost using the password “passwd123” […]

Procedure to change database password in cpanel

1. Login to cpanel using url : http://domainname/cpanel 2.clcik on mysql database >> Select the database for which yo need to change the password >> change password. 3.Now the password is sucessfully changed.