Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: woofus on March 14, 2005, 06:39:24 PM

Title: MySql problems
Post by: woofus on March 14, 2005, 06:39:24 PM

Ok I upgraded Mysql on my SME 6.0 server, dont ask me why I did it. I needed to upgrade PHP and I figured why not do Mysql as well. Well I upgraded and thought everything went fine. Webmail still worked and my databases were accessible. Well now myphpadmin doesnt work and mysqladmin is gone. I searched the forums and found people with the same problem and it looks like downgrading is the trick. How can I find out what version of Mysql I installed? I used update system and dont have the rpm file on my workstation anymore. Also I found a reference to restoring the password and getting myphpadmin to work. When I try to restore the password it gives me a stack error. If I can just get myphpadmin working I am not so worried about mysqladmin. Any ideas? I need to create a database.

Title: MySql problems
Post by: mrjhb3 on March 15, 2005, 02:36:15 AM

mysql -v
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 34 to server version: 4.0.21-standard

Reading history-file /root/.mysql_history
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

This is running my my SME 6.01-01 home production box.

JB

Title: Re: MySql problems
Post by: CharlieBrady on March 15, 2005, 03:24:39 AM

Quote from: "woofus"

Ok I upgraded Mysql on my SME 6.0 server, dont ask me why I did it.

Why did you do it?

Sorry, couldn't resist :-) I have a bit of a thing about people upgrading bits and pieces of the system when there's no clear advantage to doing so.

Title: MySql problems
Post by: mrjhb3 on March 15, 2005, 04:00:21 AM

Yep, just because.  Plus, I wanted to see if it would work with everything.  Then, when I restored from tape, I wanted to see if it would have any negative impact.  It didn't, and I am happy.  If/when I need to restore I now know that I will be able to without any issues.

That's also why I made sure I had 2 good backups just in case.

JB

Title: Re: MySql problems
Post by: woofus on March 15, 2005, 09:16:02 PM

Quote from: "CharlieBrady"

Quote from: "woofus"

Ok I upgraded Mysql on my SME 6.0 server, dont ask me why I did it.

Why did you do it?

Sorry, couldn't resist :-) I have a bit of a thing about people upgrading bits and pieces of the system when there's no clear advantage to doing so.

Yeah, lesson learned. :hammer: mysql -v doesnt do anything on my server. Maybe I messed up the path.

Title: MySql problems
Post by: woofus on March 15, 2005, 10:04:48 PM

I have Mysql version 4.1.10 and when I try to get into phpmyadmin I get this #1045 - Access denied for user 'root'@'localhost' (using password: YES)

I have created and expanded the template to use old passwords and I still cant figure out why I cant access mysqladmin, phpmyadmin or just type mysql at a prompt and issue any mysql commands. If I downgrade what version should i downgrade to?