<?php $mysqli = new mysqli('127.0.0.1', '1748124_mrep', 'mot_de_passe'); if ($mysqli->connect_error) { die('Connect Error (' . $mysqli->connect_errno . ') ' . $mysqli->connect_error); } echo 'Connection OK '.$mysqli->host_info.'<br/>'; $mysqli->close(); ?>Exécuter le script : (http://localhost/testmysql.php)
<?php $mysqli = new mysqli('127.0.0.1', '1748124_mrep', 'mot de passe', '1748124_mrep'); if ($mysqli->connect_error) { die('Connect Error (' . $mysqli->connect_errno . ') ' . $mysqli->connect_error); } echo 'Connection OK '.$mysqli->host_info.'<br/>'; if($result = $mysqli->query("SELECT DATABASE()" )) { $row = $result->fetch_row(); printf("Current database is: %s.\n", $row[0]); $result->close(); } $mysqli->close(); ?>Puis exécuter (http://localhost/testmysql.php)
.
?php // phpBB 3.1.x auto-generated configuration file // Do not change anything in this file! $dbms = 'phpbb\\db\\driver\\mysqli'; $dbhost = 'localhost'; $dbport = '3306'; $dbname = '1748124_mrep'; $dbuser = '1748124_mrep'; $dbpasswd = 'poupinette1212'; $table_prefix = 'phpbb_'; $phpbb_adm_relative_path = 'adm/'; $acm_type = 'phpbb\\cache\\driver\\file'; @define('PHPBB_INSTALLED', true); // @define('PHPBB_DISPLAY_LOAD_TIME', true); // @define('DEBUG', true); // @define('DEBUG_CONTAINER', true); define("AJAXSHOUTBOX_SHOW_APP", true);
GRANT USAGE ON *.* TO '1748124_mrep'@'127.0.0.1' IDENTIFIED BY 'poupinette1212'; GRANT USAGE ON *.* TO '1748124_mrep'@'localhost' IDENTIFIED BY 'poupinette1212'; GRANT USAGE ON *.* TO '1748124_mrep'@'::1' IDENTIFIED BY 'poupinette1212'; GRANT SELECT, INSERT, UPDATE, DELETE ON `1748124_mrep`.* TO '1748124_mrep'@'127.0.0.1'; GRANT SELECT, INSERT, UPDATE, DELETE ON `1748124_mrep`.* TO '1748124_mrep'@'localhost'; GRANT SELECT, INSERT, UPDATE, DELETE ON `1748124_mrep`.* TO '1748124_mrep'@'::1';
GRANT USAGE ON *.* TO 'lambda'@'%'; GRANT SELECT, INSERT, UPDATE, DELETE ON `lanbda`.* TO 'votre_base'@'%';Ainsi, cet utilisateur "lambda" pour la base "votre_base" pourra faire les opérations de type DML sur la base "votre_base" dans vos scripts php.