Hello ,
Please i would to know how to power up like this file in mysql it set the password for mysqls
GRANT CREATE TEMPORARY TABLES, LOCK TABLES ON *.* TO `sfri_q3xs`@'localhost' IDENTIFIED BY PASSWORD '294c884310acd503';
GRANT ALL PRIVILEGES ON `xxx\_opd`.* TO 'xxx_opduser'@'localhost';
GRANT USAGE ON *.* TO 'xxx'@'localhost' IDENTIFIED BY PASSWORD '543264861bf8f16d';
GRANT ALL PRIVILEGES ON `xxx\_opd`.* TO 'xxx'@'localhost';
GRANT USAGE ON *.* TO 'xxx'@'localhost' IDENTIFIED BY PASSWORD '543264861bf8f16d';
GRANT ALL PRIVILEGES ON `xxx\_opd`.* TO 'xxx'@'localhost';
what the command to use
mysql etc..
Thanks you

How to 'power up this file'? Do you mean how to have MySQL parse the file and follow your commands?

Put that in a file, such as filename.sql. Then:


mysql -parameters < filename.sql