Getting MySQL to work

[Guest jonnyz0109]

MySQL was already installed and running when I booted my linux box up (Mandrake 10.1) but it seems like nothing is configured, or something. mysqladmin doesn't do anything, it says command is not found. mysqld is running, I can see that, and I have the php-mysql mod installed. What I am really trying to do is install phpMyAdmin (www.phpmyadmin.net).

 

First I installed it, read the documentation, configured that inc.php file. First thing, PHP couldn't talk with the database, installing the php-mysql mod fixed that. Then everything was actually working (or seemed it, I am brand new to mysql and have never even used it, so I THINK it was all working). I went in and set the password for the 'root' user because at that point anyone could have gotten in (my webserver is public). Then it said bad authentication, so I switched auth type in the config to http so it'd ask me, but typing the username and password does not work. Now I have auth back to "config" where you put the username and password in the config file - and take a look at the message I get now: http://jonnyz.homelinux.com/phpMyAdmin/index.php.

 

1) I need to figure out what version of MySQL I'm running. You can see my PHP information here: http://jonnyz.homelinux.com/phpinfo.php

2) I tried installing the mysql package from mandrake rpm installer area, and it said it couldnt even do that...

3) How could I wipe everything MySQL-related out and reinstall from scratch using an RPM?

 

Am I doing something wrong? Please help!

 

PS: I also can't find where to set mime types for apache. For instance go to http://jonnyz.homelinux.com/phpMyAdmin - not found. You have to add in the index.php...

 

Thanks in advance,

~ Jonny

 

Note: I can't even get to mysqladmin. That leads me to believe something is wrong other then just a bad password or an old version.

 

EDIT: I just installed WebMin (www.webmin.com) and it says it can't find the MySQL server running, and it can't find mysqladmin. What is up with my install? :unsure:

[Hemtah]

your mysql version is 4.0.20

 

mysql

MySQL Support enabled

Active Persistent Links 0

Active Links 0

Client API version 4.0.20

MYSQL_MODULE_TYPE none

MYSQL_SOCKET /var/lib/mysql/mysql.sock

MYSQL_INCLUDE no value

MYSQL_LIBS no value

 

 

you can install phpmyadmin from rpm too, just go type urpmi phpMyAdmin

 

or go to your mandrake control center, uninstall unwanted package and reboot your computer then install your wanted package and reboot your computer.

 

after installing phpMyAdmin it will be located on you localhost/admin/phpMyAdmin

 

Good luck mate

 

 

MySQL was already installed and running when I booted my linux box up (Mandrake 10.1) but it seems like nothing is configured, or something.  mysqladmin doesn't do anything, it says command is not found.  mysqld is running, I can see that, and I have the php-mysql mod installed.  What I am really trying to do is install phpMyAdmin (www.phpmyadmin.net).

 

First I installed it, read the documentation, configured that inc.php file.  First thing, PHP couldn't talk with the database, installing the php-mysql mod fixed that.  Then everything was actually working (or seemed it, I am brand new to mysql and have never even used it, so I THINK it was all working).  I went in and set the password for the 'root' user because at that point anyone could have gotten in (my webserver is public).  Then it said bad authentication, so I switched auth type in the config to http so it'd ask me, but typing the username and password does not work.  Now I have auth back to "config" where you put the username and password in the config file - and take a look at the message I get now: http://jonnyz.homelinux.com/phpMyAdmin/index.php.

 

1) I need to figure out what version of MySQL I'm running.  You can see my PHP information here: http://jonnyz.homelinux.com/phpinfo.php

2) I tried installing the mysql package from mandrake rpm installer area, and it said it couldnt even do that...

3) How could I wipe everything MySQL-related out and reinstall from scratch using an RPM?

 

Am I doing something wrong?  Please help!

 

PS: I also can't find where to set mime types for apache.  For instance go to http://jonnyz.homelinux.com/phpMyAdmin - not found.  You have to add in the index.php...

 

Thanks in advance,

~ Jonny

 

 

Note: I can't even get to mysqladmin.  That leads me to believe something is wrong other then just a bad password or an old version.

 

EDIT: I just installed WebMin (www.webmin.com) and it says it can't find the MySQL server running, and it can't find mysqladmin.  What is up with my install?  :unsure:

<{POST_SNAPBACK}>