Guest User

Untitled

a guest
Apr 22nd, 2018
125
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.63 KB | None | 0 0
  1. try {
  2. $dsn = 'mysql:host=localhost;dbname=chat';
  3. $username = 'chat';
  4. $password = '1234';
  5. $options = array(
  6. PDO::MYSQL_ATTR_INIT_COMMAND = > 'SET NAMES utf8',
  7. );
  8. $dbh = new PDO($dsn, $username, $password, $options);
  9. } catch (PDOException $e) {
  10. echo $e->getMessage();
  11. }
  12.  
  13. $dsn = 'mysql:host=localhost;dbname=chat;charset=utf8';
  14. $username = 'chat';
  15. $password = '1234';
  16. $options = array(
  17. PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
  18. );
  19. $dbh = new PDO($dsn, $username, $password, $options);
  20.  
  21. CREATE USER 'chat'@'%' IDENTIFIED BY 'password';
  22. GRANT ALL PRIVILEGES ON chat.* TO 'chat'@'localhost';
Add Comment
Please, Sign In to add comment