Advertisement
Guest User

Untitled

a guest
Jun 30th, 2017
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.67 KB | None | 0 0
  1. "ERROR 1044 (42000) at line 39: Access denied for user 'drupal_user'@'localhost' to database 'mydb'"
  2.  
  3. $local_sites = '/Users/steve/Sites/';
  4. $aliases['local'] = array(
  5. 'uri' => 'default',
  6. 'root' => $local_sites . 'mysite/public_html',
  7. 'path-aliases' => array(
  8. '%files' => $local_sites . 'mysite/public_html/sites/default/files',
  9. '%dump-dir' => '/Users/steve/Sites/mysite',
  10. ),
  11. );
  12.  
  13. $aliases['prod'] = array(
  14. 'uri' => 'default',
  15. 'os' => 'Linux',
  16. 'root' => '/cluster/www_system/www/www.mysite.org/current_build/public_html',
  17. 'remote-host' => 'control.cphwf01.local',
  18. 'remote-user' => 'sedwards',
  19. 'path-aliases' => array(
  20. '%files' => 'sites/default/files',
  21. '%dump-dir' => '/scratch',
  22. ),
  23. );
  24.  
  25. Calling system(mysql --database=mydb --host=localhost --user=drupal_user --password=mypass --silent < /Users/steve/Sites/mysite/mysiteLeW4G5);
  26.  
  27. mysql --database=mydb --host=localhost --user=drupal_user --password=mypass
  28.  
  29. GRANT ALL PRIVILEGES ON `myDB`.* TO 'mySQLuser'@'localhost' WITH GRANT OPTION
  30.  
  31. GRANT USAGE ON *.* TO 'mySQLuser'@'localhost' IDENTIFIED BY PASSWORD 'pwd'
  32.  
  33. $aliases['local'] = array( 'uri' => 'http://yoursite.local', 'root' => $local_sites . 'all/themes/yourtheme/', 'path-aliases' => array(
  34. '%dump-dir' => $local_sites . 'all/drush/dbdumps',
  35. '%files' => 'sites/default/files', ), 'databases' => array(
  36. 'default' =>
  37. array(
  38. 'default' =>
  39. array(
  40. 'database' => 'db_name',
  41. 'username' => 'user',
  42. 'password' => 'pass',
  43. 'host' => '127.0.0.1',
  44. 'port' => '',
  45. 'driver' => 'mysql',
  46. 'prefix' => '',
  47. ),
  48. ), ), );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement