code_junkie

MySQL-problem when baking with CakePHP

Nov 12th, 2011
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.78 KB | None | 0 0
  1. Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) in /Applications/MAMP/htdocs/blog/cake/libs/model/datasources/dbo/dbo_mysql.php on line 117
  2.  
  3. Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /Applications/MAMP/htdocs/blog/cake/libs/model/datasources/dbo/dbo_mysql.php on line 122
  4.  
  5. Warning: mysql_get_server_info(): supplied argument is not a valid MySQL-Link resource in /Applications/MAMP/htdocs/blog/cake/libs/model/datasources/dbo/dbo_mysql.php on line 130
  6.  
  7. Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /Applications/MAMP/htdocs/blog/cake/libs/model/datasources/dbo/dbo_mysql.php on line 154
  8. Error: Your database does not have any tables.
  9.  
  10. class DATABASE_CONFIG {
  11.  
  12. var $default = array(
  13. 'driver' => 'mysql',
  14. 'connect' => 'mysql_connect',
  15. 'persistent' => false,
  16. 'host' =>':/Applications/MAMP/tmp/mysql/mysql.sock', // UNIX MySQL-socket
  17. 'login' => 'my_user',
  18. 'password' => 'my_pass',
  19. 'database' => 'blog',
  20. 'prefix' => '',
  21. );
  22.  
  23. }
  24.  
  25. Warning: mysql_connect(): Can't connect to local MySQL server through socket '/Applications/MAMP/tmp/mysql/mysql.sock:3306' (2) in /Applications/MAMP/htdocs/blog/cake/libs/model/datasources/dbo/dbo_mysql.php on line 117
  26.  
  27. Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /Applications/MAMP/htdocs/blog/cake/libs/model/datasources/dbo/dbo_mysql.php on line 122
  28.  
  29. Warning: mysql_get_server_info(): supplied argument is not a valid MySQL-Link resource in /Applications/MAMP/htdocs/blog/cake/libs/model/datasources/dbo/dbo_mysql.php on line 130
  30.  
  31. Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /Applications/MAMP/htdocs/blog/cake/libs/model/datasources/dbo/dbo_mysql.php on line 154
  32. Error: Your database does not have any tables.
  33.  
  34. # Don't listen on a TCP/IP port at all. This can be a security enhancement,
  35. # if all processes that need to connect to mysqld run on the same host.
  36. # All interaction with mysqld must be made via Unix sockets or named pipes.
  37. # Note that using this option without enabling named pipes on Windows
  38. # (via the "enable-named-pipe" option) will render mysqld useless!
  39. #
  40. #skip-networking
  41.  
  42. 'host' =>'localhost'
  43.  
  44. class DATABASE_CONFIG {
  45.  
  46. var $default = array(
  47. 'driver' => 'mysql',
  48. 'persistent' => false,
  49. 'host' => 'localhost',
  50. 'port' => '/Applications/MAMP/tmp/mysql/mysql.sock', // here is the key !
  51. 'login' => 'you',
  52. 'password' => 'yourpass',
  53. 'database' => 'yourdb',
  54. 'prefix' => '',
  55.  
  56. );
  57.  
  58. my-macbook:~ chris$ php -i | grep mysql.default_socket
  59. mysql.default_socket => no value => no value
  60. my-macbook:~ chris$ php -i -c /Applications/MAMP/conf/php5 | grep mysql.default_socket
  61. mysql.default_socket => /Applications/MAMP/tmp/mysql/mysql.sock => /Applications/MAMP/tmp/mysql/mysql.sock
  62.  
  63. sudo ln -s /Applications/MAMP/tmp/mysql/mysql.sock /tmp/mysql.sock
  64.  
  65. class DATABASE_CONFIG
  66. {
  67. public $default = array(
  68. 'driver' => 'mysql',
  69. 'persistent' => false,
  70. 'host' => 'localhost',
  71. 'login' => 'account',
  72. 'password' => 'password',
  73. 'database' => 'database',
  74. 'prefix' => '',
  75. 'port' => '/var/mysql/mysql.sock'
  76. );
  77. }
  78.  
  79. class DATABASE_CONFIG
  80. {
  81. public $default = array(
  82. 'driver' => 'mysql',
  83. 'persistent' => false,
  84. 'host' => 'localhost',
  85. 'login' => 'account',
  86. 'password' => 'password',
  87. 'database' => 'database',
  88. 'prefix' => '',
  89. 'port' => '/Applications/MAMP/tmp/mysql/mysql.sock'
  90. );
  91. }
Add Comment
Please, Sign In to add comment