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” […]

How to Back Up MySQL Database

How to backup  mysql database. If you’re storing anything in MySQL databases that you do not want to lose, it is very important to make regular backups of your data to protect it from loss You can take backup Through command line. Back up From the Command Line (using mysqldump) If you have shell or telnet […]

How To Create Table in MY SQl Databse In Plesk Control Panel

For creating table. Login to your plesk control panel. step1-click database icon “Databases” step2-click icon “Add New Database” for adding new database. step3-otherwise select the old database setp4-Add new user for that database step5-click web admin icon setp6-Here you can see the list of table step7-For add new table click sql icon step8-execute query for […]