You can directly update password using the following method to update or change password for user vivek:
1) Login to mysql server, type the following command at shell prompt:
$ mysql -u root -p
Category Archives: MySQL
How to open remote access to MySQL
To enable mySQL remote connection we need to follow these steps:
Recover MySQL root password
If you ever loose your mysql root password (remember is not the same as the system root password) you can recover it following this steps:
How to interact with MySQL inside AGI
Reading from MySQL Database
The following AGI retrieves asterisk extensions from Asterisk database in MySQL and displays them as verbose.
How to backup/Restore in mysql
Dump all databases for backup. Backup file is sql commands to recreate all db’s.
# mysqldump -u root -ppassword --opt > alldatabases.sql
Dump one database for backup.
# [mysql dir]/bin/mysqldump -u username -ppassword --databases databasename >/tmp/databasename.sql
Dump a table from a database.
# mysqldump -c -u username -password databasename tablename > /tablename.sql
Restore database (or database table) from backup.
# mysql -u username -password databasename < /tmp/databasename.sql
Load a CSV file into a table.
mysql> LOAD DATA INFILE '/tmp/filename.csv' replace INTO TABLE [table name] FIELDS TERMINATED BY ',' LINES TERMINATED BY 'n' (field1,field2,field3);