• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

phpMyAdmin help

#1
Whilst this isn't exactly related to xenforo I was wondering if anyone could help, I had to reinstall xenforo due to messing some stuff up and in the process I'm not sure what I did but I completely messed up phpmyadmin ins the process as well. It prompts me with a login page, I put in the pass word that it says in my config.inc.php but then I am prompted with 1045# Cannot log in to my SQL Server.

This is what my config.inc.php says

<?php
/*
* Generated configuration file
* Generated by: phpMyAdmin 4.1.14 setup script
* Date: Mon, 15 Jun 2015 13:02:08 +0200
*/

/* Servers configuration */
$i = 0;

/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = '';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'user';
$cfg['Servers'][$i]['password'] = 'jade';


/* End of servers configuration */

$cfg['blowfish_secret'] = '557eafd496aa37.98980975';
$cfg['DefaultLang'] = 'en';
$cfg['ServerDefault'] = 1;
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
?>

The above username or password does not work. If anyone can help I would be so grateful! thanks :)
 
#3
Perhaps there is more than one user on the account?
$cfg['Servers'][$i]['user'] = 'screechout_user';
$cfg['Servers'][$i]['password'] = 'password';
Thanks for the reply! I've fixed it but uninstalling and reinstalling luckily I didn't need to keep any data!

But I have another small problem which was my initial problem to begin with Access denied for user 'root'@'localhost' (using password: NO) I get this error when setting up Xenforo, would you be able to help with this? thanks!
 

BoostN

Active member
#4
Thanks for the reply! I've fixed it but uninstalling and reinstalling luckily I didn't need to keep any data!

But I have another small problem which was my initial problem to begin with Access denied for user 'root'@'localhost' (using password: NO) I get this error when setting up Xenforo, would you be able to help with this? thanks!
That error is telling you the Username/Password is incorrect or permissions are not correctly setup for the user on the database.

If your using phpmyadmin, just go to User--> Add Users, fill out the information. Check the Create Database and Grant Privileges option.

db-users.JPG
 
#5
That error is telling you the Username/Password is incorrect or permissions are not correctly setup for the user on the database.

If your using phpmyadmin, just go to User--> Add Users, fill out the information. Check the Create Database and Grant Privileges option.

View attachment 108517
I am using phpmyadmin, when you say go to users, I do not see a tab for that. I'm very new to everything so I'm not sure where to find this, would this be in the database?
 
#10
upload_2015-6-15_13-43-46.png


This is what I was originally trying to set it up like,

Then on Xenforo: MySQL Username: root
MySQL Database Name: Forums

The same with the method that you said above, I'm sure I'm doing something incorrect here :/
 

BoostN

Active member
#13
I'm using XAMPP, but I did I have it happen to me. I resorted to the method above (create user, then db) and I was able to set everything up.
 
#14
I'm using Wamp, not sure how I got it to fix the first time. This is what it looks like when I go onto the users tab. Not sure if this means anything, but just in case

upload_2015-6-15_14-6-9.png