Article:		Web Apps with Tiger: MediaWiki
Subject:		installation: Connection failed MediaWiki 1.5.2
Date:		2005-11-26 10:29:17
From:		anne001
How many passwords are there? on the 4 lines starting with mysqladmin I entered the mysql password each time a password was requested. That seemed to work. What are those 4 lines doing? Are we setting up a password for wiki_user? When will it be needed? How do you change it? /wiki/config/index.php Database config snags: connection failed If I had copied the lines verbatim what would I put? MySQL server localhost Database name wiki_dbname DB username wiki_user DB password ? ?

Showing messages 1 through 3 of 3.

• installation: Connection failed MediaWiki 1.5.2
  2005-12-06 04:34:40  anne001 [View]
  
  
  I gave up. I installed php5.04 from a package, very easy.
  
  I uninstalled mysql (marc liyanage site also)
  I installed the latest mysql, made sure it was started (button in preferences)
  
  I created a database as per this tutorial, skipping the old password line.
  
  I ran the mediawiki installation, done. Not worth fighting with old stuff. Of course some programs don't work with php5 and I don't know which... Oh well

• installation: Connection failed MediaWiki 1.5.2
  2005-11-26 11:25:32  anne001 [View]
  
  
  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
  
• 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.