PHPMyAdmin? in Off Topic

ID:185362
 
Feb 22 2006, 9:31 am
I'm trying to login to PHPMyAdmin and on each attempt it says I gave either a wrong username, wrong password, or both. I set the username in the config.inc file and set the password in mysql_password then set the auth_type to 'http', and no matter what I do it keeps giving me that error.
#1 Feb 22 2006, 9:33 am
I had phpmyadmin installed into my web directory on my computer.. I don't know how your using it.. but I thought using it is simple just config the files and create a virtual Directory (thats if its on your computeR) and just set it to the mysql databaseisnt really that hard. The password is for YOUR "Mysql" if you know the mysql password to get in and out like for example
user: Root
Pass: admin

(not enitrely sure this is helpful so..)
(Ill see if i can if ill resetup my phpadmin)
#2 Feb 22 2006, 9:40 am (Edited on Feb 22 2006, 4:15 pm)
#3 Feb 22 2006, 9:42 am
In response to Nadrew (#2)
I set the 'username' variable to 'artemio', but I left the password to implode() (it did say that it wasn't needed unless I use 'config'), but I use 'artemio' and the password set in the mysql_password file and it doesn't work. So how would I set the UN/PW for HTTP authentication?

I first left it as 'config' but I still got the same error.
I even tried setting the password directly in config.inc for both auth types and got the same error.
#4 Feb 22 2006, 9:49 am (Edited on Feb 22 2006, 4:15 pm)
In response to Artemio (#3)
#5 Feb 22 2006, 9:49 am
In response to Nadrew (#4)
Positive.

$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http
or cookie based)?
$cfg['Servers'][$i]['user'] = 'artemio'; // MySQL user
$cfg['Servers'][$i]['password'] = implode('',file('../mysql_password'));
#6 Feb 22 2006, 10:04 am (Edited on Feb 22 2006, 4:15 pm)
In response to Artemio (#5)
#7 Feb 22 2006, 10:39 am
In response to Nadrew (#6)
I just reinstalled, apparantly it doesn't want you to log in if you set a different password than "root" in mysql_password.

I have another problem, though. I'm using Yuugi's scoreboard system- I made the table and all the fields, and the page never loads.
<?
/*  Database Information - Required!!  */
/* -- Configure the Variables Below --*/
$dbhost = '68.56.69.178:80';
$dbusername = '//editedout\\';
$dbpasswd = '//editedout\\';
$database_name = '68.56.69.178';

/* Database Stuff, do not modify below this line */

$connection = mysql_pconnect("$dbhost","$dbusername","$dbpasswd")
    or die ("Couldn't connect to.");

$db = mysql_select_db("$database_name", $connection)
    or die("Couldn't select database.");
?>
#8 Feb 22 2006, 10:43 am (Edited on Feb 22 2006, 4:15 pm)
In response to Artemio (#7)
#9 Feb 22 2006, 10:51 am (Edited on Feb 22 2006, 10:57 am)
In response to Nadrew (#8)
Now I get "couldn't select database" after changing database_name to "highscore" and dbhost to "localhost".
#10 Feb 22 2006, 12:18 pm (Edited on Feb 22 2006, 4:15 pm)
In response to Artemio (#9)
#11 Feb 22 2006, 12:23 pm
In response to Nadrew (#10)
I went into PHPMyAdmin, went to the MySQL database, and added a "highscore" table with the appropriate fields.

Screenshot.
#12 Feb 22 2006, 12:24 pm (Edited on Feb 22 2006, 4:14 pm)
In response to Artemio (#11)
#13 Feb 22 2006, 12:25 pm
In response to Nadrew (#12)
It's on the same server, yes.
#14 Feb 22 2006, 1:38 pm (Edited on Feb 22 2006, 4:14 pm)
In response to Artemio (#13)
#15 Feb 22 2006, 2:27 pm
In response to Nadrew (#14)
didn't notice if this was mentioned, but often times you need to reload the mysql server for certain changes (like a username/password, or creating a database) before you work with those changes. so setting the database username/pass, reloading, *then* updating that info in your phpmyadmin config, should have worked.
#16 Feb 22 2006, 2:30 pm
In response to digitalmouse (#15)
I already tried that, but I just set it in PHPMyAdmin when I reinstalled.

Last problem: Names with a single quotation mark in them fsk up the link, how do I fix it?