LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 07-15-2003, 05:19 PM   #1
BGuarnieri
LQ Newbie
 
Registered: Apr 2003
Location: Warren OH
Distribution: Redhat 9
Posts: 6

Rep: Reputation: 0
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
 
Old 07-15-2003, 05:43 PM   #2
esromneb
LQ Newbie
 
Registered: Jul 2003
Posts: 4

Rep: Reputation: 0
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
 
Old 07-15-2003, 05:56 PM   #3
BGuarnieri
LQ Newbie
 
Registered: Apr 2003
Location: Warren OH
Distribution: Redhat 9
Posts: 6

Original Poster
Rep: Reputation: 0
Quote:
It's configured to login through http instead of cookie/config.
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
--------------

Last edited by BGuarnieri; 07-15-2003 at 06:08 PM.
 
Old 07-15-2003, 06:12 PM   #4
the.jxc
LQ Newbie
 
Registered: Jun 2003
Posts: 14

Rep: Reputation: 0
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.
 
Old 07-15-2003, 07:06 PM   #5
BGuarnieri
LQ Newbie
 
Registered: Apr 2003
Location: Warren OH
Distribution: Redhat 9
Posts: 6

Original Poster
Rep: Reputation: 0
err ok how do i find out package name?
 
Old 07-15-2003, 07:08 PM   #6
the.jxc
LQ Newbie
 
Registered: Jun 2003
Posts: 14

Rep: Reputation: 0
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
 
Old 07-15-2003, 07:09 PM   #7
BGuarnieri
LQ Newbie
 
Registered: Apr 2003
Location: Warren OH
Distribution: Redhat 9
Posts: 6

Original Poster
Rep: Reputation: 0
Thanks.. it seems to be uninstalling.
 
Old 07-15-2003, 07:10 PM   #8
BGuarnieri
LQ Newbie
 
Registered: Apr 2003
Location: Warren OH
Distribution: Redhat 9
Posts: 6

Original Poster
Rep: Reputation: 0
is there anyway to not have to type those long file names when installing packages?
 
Old 07-15-2003, 07:14 PM   #9
BGuarnieri
LQ Newbie
 
Registered: Apr 2003
Location: Warren OH
Distribution: Redhat 9
Posts: 6

Original Poster
Rep: Reputation: 0
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]#
 
Old 07-15-2003, 08:19 PM   #10
Road
Member
 
Registered: Jan 2002
Distribution: Debian Based only but have tried most others.
Posts: 82

Rep: Reputation: 15
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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
mySQL install from RPM (where is it??) shycalais Linux - Software 8 10-30-2003 08:56 PM
MySQL mysql-3.23.56-1.9, rpm install problem jacsmith510 Linux - Newbie 3 09-19-2003 03:02 PM
mysql rpm install: Didn't find /usr/libexec/mysqld rioguia Linux - Software 2 01-27-2003 09:56 AM
RPM install for MySQL needamiracle Linux - Software 3 07-09-2002 04:30 PM
Help Me. I am trying to install MySql-3.23.42 rpm 3MTA3 Linux - Software 7 09-19-2001 08:49 PM


All times are GMT -5. The time now is 11:06 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration