Web Apps with Tiger: MediaWiki
Subject:   installation: Connection failed MediaWiki 1.5.2
Date:   2005-12-05 04:31:22
From:   anne001
Response to: installation: Connection failed MediaWiki 1.5.2

First I need to figure out if mysql works, and if the databases were created, and with what passwords.
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.