droit [grant] de l'utilisateur root@localhost à la BdD MySQL

[GoogleCodeExporter]

Le commande pour donner les droits à l'utilisateur root@localhost à la base 
de données MySql : 
GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY 'toto' WITH GRANT 
OPTION;
dans cet exemple toto est le mot de passe.

Original issue reported on code.google.com by simon.eric028@gmail.com on 2 Aug 2012 at 6:48

[GoogleCodeExporter]

modif dans le fichier de conf de phpMyAdmin : config.inc.php
/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = 'localhost';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'toto';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

modif dans le fichier php.ini
; Default password for mysql_connect() (doesn't apply in safe mode).
; Note that this is generally a *bad* idea to store passwords in this file.
; *Any* user with PHP access can run 'echo get_cfg_var("mysql.default_password")
; and reveal this password!  And of course, any users with read access to this
; file will be able to reveal the password as well.
; http://php.net/mysql.default-password
mysql.default_password = toto

Original comment by simon.eric028@gmail.com on 2 Aug 2012 at 12:49