LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   Need MySQL Help (https://www.linuxquestions.org/questions/linux-newbie-8/need-mysql-help-35500/)

Park_7677 11-14-2002 11:24 PM

Need MySQL Help
 
While I'm not a newbie @ MySQL nor PHP I don't know how to fix an error in Linux.


When I use phpMyAdmin I get the following:

------------------------------------------------------------------------

Welcome to phpMyAdmin 2.3.2

Error

MySQL said:

Access denied for user: 'root@localhost' (Using password: NO)

------------------------------------------------------------------------

Does anyone know where the config files are for MySQL? Any tips to fix this without ripping my hair out?! If you're wanting to ask how I got this error.....

1. Installed MySQL with Linux install.
2. Newer version released so I downloaded the RPM. I uninstalled the old version and installed the new.
3. Everything's fine. MySQL works but the PHP-MySQL extensions do not. I uninstalled the new version of MySQL and reinstalled the one from my dist CD. PHP-MySQL extensions work now but user problems are now present.


That brings me to posting this.

THANKS FOR ANY HELP!

::Ross_

GT I.N.C 11-14-2002 11:40 PM

So did you install phpmyadmin and mysql in root?

#Garry

Park_7677 11-14-2002 11:55 PM

Yes, Root. Was that a bad move?

GT I.N.C 11-15-2002 12:02 AM

Not neccessarily...

Did you log in as root, or just switch to root temporairly via console?

Cause you really shouldn't log soley as root...

Can you try re-installing it as a normal user, then 'su' when necessary...

#Garry

Park_7677 11-15-2002 12:07 AM

Logged In. If I did something bad... I plan on reinstalling RH8 clean once I learn the basic do's and dont's.

GT I.N.C 11-15-2002 12:11 AM

No nothing bad, it's just that root has power over EVERYTHING and if you do something wrong you can get yourself in some trouble :p

Try installing as a normal user...

#Garry

Park_7677 11-15-2002 12:13 AM

Let me try.... just that the CD-ROM is loud when opening/closing and my mom is trying to sleep! lol. I'm not supposed to be up :D!

Park_7677 11-15-2002 12:29 AM

What I did:

stopped httpd
stopped mysqld

uninstalled mysql
installed mysql

start mysqld
start httpd

--------------------------------------------------------------------

Welcome to phpMyAdmin 2.3.2

Error

MySQL said:

Access denied for user: 'root@localhost' (Using password: NO)

--------------------------------------------------------------------

Same error. I give up. No big deal. I have a new box to be built (a very nice one) next week and is the target linux box. I was just learning on this one. It's 12:30 so I'm off to bed. Thanks

GT I.N.C 11-15-2002 12:34 AM

Ok no worries...

Good night :p

#Garry

mace 11-16-2002 02:08 PM

http://www.rocketry.org/~tim/geek_stuff/mysql.php

supplies a good tut. for installing by scratch.


All times are GMT -5. The time now is 09:07 PM.