Andrew (wspnut) wrote in lj_everywhere,

MySQL Problems

I couldn't find this answer through my own research, and a few people I asked on the matter had no clue either so I will post here...

When installing the LJ MySQL database, I type this:

# mysql -uroot -p
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8 to server version: 3.23.49

mysql> GRANT ALL PRIVILEGES ON livejournal.* TO
-> lj@localhost IDENTIFIED BY 'passhere';
Query OK, 0 rows affected (0.01 sec)

mysql> \q

# cd $LJHOME
# bin/upgrading/ --runsql --populate
Can't connect to the database (clust#0), so I can't update it.

I'm really confused on what's going on and why it's thinking clust#0 is the database. In lj_config there is no dbname set, so I don't know hy it would look for something other than 'livejournal' as the database name.

Anyway, if any of you know what this error is or even how to correct it, I would be much obliged.

Update - My apache server wasn't running because of errors, but I cannot comprehend why the errors are occouring (they have to do with the httpd.conf file, yet I took the example nearly straight out of the server-docs). More details in comments...

  • Post a new comment


    Comments allowed for members only

    Anonymous comments are disabled in this journal

    default userpic

    Your IP address will be recorded