Topic: Geeklog install issue with mysql

[arnoldob]

I was running through the geeklog contrib by Abe Lovelss and ran into a snag:
[root@server root]# rpm -Uvh smeserver-geeklog-1.3.9*.noarch.rpm
Preparing...                ########################################### [100%]
   1:smeserver-geeklog-1.3.9########################################### [100%]
Gracefully reloading httpd: [   OK   ]
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'
Creating database...
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'

I assume this is because I set a password for mysql root user as recommended at mysql.org  So, how do I make this rpm install run correctly? I don't see a way of removing the root password to do the install on the mysql.org website. I have never really messed with mysql before. Any suggestions?

[arnoldob]

Anybody have any ideas on this?
Thanks

[ergozd]

It is mysql user/password issue

Try to run

http://your-server/geeklog/admin/install/

OR
copy /opt/geeklog-1.3.9/sql/mysql_tabelanddata.php file somewhere you can access via webbrowser and try to run it.

Good luck.

[Anonymous]

I tried re-running the install page you suggested. But that made no difference. I found this in another thread:

http://forums.contribs.org/index.php?topic=22343.msg88673#msg88673

It suggests trying this:

[root@tuxtest /root] # /etc/rc.d/init.d/mysqld stop
[root@tuxtest  /root # /etc/esmith/events/actions/conf-mysql-password
[root@tuxtest /root] # /etc/rc.d/init.d/mysqld start

That sets the mysql root password back to default

There's a helpful howto here as well:
http://www.familybrown.org/howtos/mysql-password-howto.html

[arnoldob]

oops forgot to login again