In your mysql conf file there should be a commented parameter
that looks like:
#port = 3306

Remote the sharp:
port = 3306

Then restart mysqld ( as root: /etc/init.d/mysqld restart )

For help / support, feel free to come on irc irc://irc.freenode.net/mediawiki

oh and to get version of installed software, you can often use
the --version switch. Examples:

php --version
mysql --version

thatotherdude wrote:

k, i got my version numbers, but i cant download irc.
php is version 5.0.4
mysql is version 4.1.11

I think that port thing would solve my problem however i dont even know where
sql files are stored :P

If someone could tell me how to access my conf file (as mentioned above) that
would help a ton!

Thanks,
Rob

/etc/my.cnf

or /etc/mysql/my.cnf

make sure you look at your distribution documentation :)

thatotherdude wrote:

wow this is bad, i thought i was moderately tech savy.... i found the file, but
theres no commented out port number

Heres the entire document:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

1. Default to using old password format for compatibility with mysql 3.x
2. clients (those using the mysqlclient10 compatibility package).

old_passwords=1

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Also where is this distribution documentation your talking about.

Thanks again for your help,
Rob

Raphael.Becker wrote:

Similar problem here (mediawiki 1.5.3, MySQL 5.0.15, PHP 5.1.1):

Using a database-server other than localhost results in adding a
MySQL-permission for Host='%' in the mysql.user and mysql.db databases when
using the automatic setup (under mysql-root). Everything runs fine from the
mysql-shell, when loggin in with the wiki-user and the wiki-passwd using "-h
localhost" (default), but fails with using "-h mysql.example.com", if this
resolves into anything else but 127.0.0.1 but is still on the "local host"
(using an interface-IP 192.168.0.134 for example)

Manual Fix: Changeing the Host '%' for wikiuser in mysql.db and mysql.user to
the real systems name (DNS reverse lookup) and doing "flush privileges" is all
to get it working.

Suggested fix: Don't use '%' in the 'Host'-column but try to determine the
"incoming"-IP address (192.168.0.134 for example) when setting up the tables
using MySQL-root user and use this value instead.

I didn't find out when (which release) MySQL broke Host='%'.

Regards
Raphael Becker

robchur wrote:

MySQL configuration issue, not our problem.