Mysql rpm re-install question.
 

Okay guys, this is my first day using Linux (all cheer for me!) and I'm running Red Hat Linux version 9 with the majority of the updates (except kernal).

Anyways, I successfully installed Apache 1.3.x from source and also installed PHP 4.3.x from source. They both work, I've tested them. I go to install mysql from rpm binary (4.0.13) and it works...... or seems to.. as I can connect like this from console..

mysql -u root -p <ENTER>
then i type my pass, and it lets me in.

However, I try to run phpMyAdmin and I can never connect, it always gives me this error message even though i type the correct user/pass in.

"
Welcome to phpMyAdmin 2.5.2-rc2

Wrong username/password. Access denied.

"

It's configured to login through http instead of cookie/config.

I think I might have done something wrong with setting up the password in the beggining or something. I don't understand why this is messing up.


Anyways, I'd like to re-install the mysql server/client. I try this..

rpm -e Mysql-server-version.rpm Mysql-client-version.rpm and it says it doesn't exist.

so I'm like okay cool and do...

rpm -i server client and it says they're already installed.

I don't understand :(

Can someone please tell me how to reinstall these rpm's.. I've googled like crazy and come up with nil :(

You should try using http login. just edit your config.inc.php file and make it look like
$cfg['Servers'][$i]['auth_type'] = 'http';
if you do that I think you also need to change user and pass to blank in that file...but I'm not sure...good luck

I'd like to know how to reinstall the mysql server. It must not be setup right because phpmyadmin wont work but the mysql console will.

[edit] update....

ran a small php mysql_connect() or die() test and got this.

Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /www/htdocs/mysql.php on line 3
Cannot connect to mysql server: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

in console i get this when i do a status (mysql -u root -p, enter pass, hit enter)

mysql Ver 12.20 Distrib 4.0.13, for pc-linux (i686)

Connection id: 3
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Server version: 4.0.13
Protocol version: 10
Connection: Localhost via UNIX socket
Client characterset: latin1
Server characterset: latin1
UNIX socket: /var/lib/mysql/mysql.sock
Uptime: 32 sec

Threads: 1 Questions: 2 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.062
--------------

When you install an rpm package, you specify the file name from which it is to install.

e.g rpm -i kdepim-3.1-5.i386.rpm

When you uninstall, you give the package name, not the file name.

e.g. rpm -e kdepim

J.

err ok how do i find out package name?

It's the bit before the numbers. It'll be one of....

mysql
mysql-server
mysql-devel

You said it was the server package, yeah? Try rpm -e mysql-server

Thanks.. it seems to be uninstalling.

is there anyway to not have to type those long file names when installing packages?

Ugh, okay I thought this was supposed to uninstall it... I uninstalled and reinstalled, and it says to set my password with the command ...

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h serverbox password 'new-password'

so I do that and I get...
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
[root@serverbox webserver]#

Make sure you unistalled all of the mysql packages. You can a list of your MySQL packages by doing the following:

rpm -qa |grep MySQL

Be sure to have the "MySQL" with the correct capitalization because this is cap sensitive.

Road