Article:		Web Apps with Tiger: MediaWiki
Subject:		installation: Connection failed MediaWiki 1.5.2
Date:		2005-11-26 11:25:32
From:		anne001
Response to: installation: Connection failed MediaWiki 1.5.2
Actually, near the top is more info on the error. The first error was a problem looking for socket in a var/mysql which did not exist. After rebooting my computer, the error changed to MySQL error 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client which the lines with Old_password and flush... are supposed to avoid. http://dev.mysql.com/doc/refman/5.0/en/old-client.html

Showing messages 1 through 1 of 1.

• installation: Connection failed MediaWiki 1.5.2
  2005-12-05 04:31:22  anne001 [View]
  
  
  First I need to figure out if mysql works, and if the databases were created, and with what passwords.
  
  http://dev.mysql.com/doc/refman/5.0/en/post-installation.html
  is useful I think
  
  as someone recommended for newbies
  sudo /Library/StartupItems/MySQLCOM/MySQLCOM start
  Starting MySQL database server
  just in case, since that has already been a problem.
  
  mysqladmin -u root -p ping
  with my sqladmin password works:
  mysqld is alive
  
  mysqladmin -u wiki_user -p ping
  works with a password I chose
  
  mysql -u root -p -e "show grants for 'wiki_user'"
  Grants for wiki_user@% |
  GRANT USAGE ON *.* TO 'wiki_user'@'%' IDENTIFIED BY PASSWORD '******' |
  GRANT ALL PRIVILEGES ON `wiki_dbname`.* TO 'wiki_user'@'%'
  
  I don't know how many databases, or users I created by mistake,
  but I seem to have a database wiki_dbname and a user wiki_user
  with a password of my own choosing.