PhpMyAdmin Problems

 
Post new topic   Reply to topic    Aprelium Forum Index -> PHP
View previous topic :: View next topic  
Author Message
pagekeeper
-


Joined: 09 Jul 2003
Posts: 35
Location: London, UK

PostPosted: Fri Jul 11, 2003 9:21 pm    Post subject: PhpMyAdmin Problems Reply with quote

Hi,

Ok great now im nearly finished but there is still one more thing to do.

So far i have set the following and all works

Abyss
MySQL
Php
Phpmyadmin is great but im not sure what to use for? easier to configure what exactly? databases riggght? :?
The other point is i need help on how to set the security ie the password i cant set it with out geting an error so if you could help on these i will be happy. :D
(phpmyadmin) i did take a look at the tutorials thats how i installed it, but i i seem to have the lastest version and unsure. lines in question are 79 80 81

$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed[/quote]
_________________
Ashley Parmessur - Pagekeeper
Back to top View user's profile Send private message
datwig
-


Joined: 26 Jan 2003
Posts: 85

PostPosted: Sat Jul 12, 2003 3:27 am    Post subject: Reply with quote

PHPMyAdmin is for MySQL database controling.

What do you mean set the password? What password? (MySQL, ABYSS)?
Back to top View user's profile Send private message AIM Address
pagekeeper
-


Joined: 09 Jul 2003
Posts: 35
Location: London, UK

PostPosted: Sat Jul 12, 2003 3:54 am    Post subject: Reply with quote

Well i want to password protect all MySQL, phpMyadmin?

Just a step by step on how to set each program? -

Because when i do set a password i get a root error,

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

I changed root to user under priviliges i think this has something to do with it, so how do you get the computer to reconise the change? :?
_________________
Ashley Parmessur - Pagekeeper
Back to top View user's profile Send private message
SonnyB
-


Joined: 19 Jun 2003
Posts: 42
Location: New York USA

PostPosted: Mon Jul 14, 2003 5:42 am    Post subject: Password Help Reply with quote

In PHPMYADMIN found at http://localhost/phpmyadmin
Set as so:

Go to privileges.
You will see a set of four areas
Example:
USER HOST PASSWORD
ANY % No/ Or yes If you put one
ANY localhost No/ Or yes if you put one
root % No or Yes
root localhost No or Yes

On those fields you should only have to pass your root fields leave the "user" any fields with no pass

Should look like so

USER HOST PASSWORD
ANY % NO
ANY localhost NO
root % yes
root localhost yes

Once you are done Reload your MySQL.

Then Exit MySQL And relaunch MySQL

When Config. Any PHP Programs that use MySQL And require A database

Your User Name = root
Your Pass = your pass
Your Host= localhost
Your database = a database you made

Example on a ladder script config file
// MYSQL DATABASE INFO

$db[host] ='localhost';
$db[uname] ='root';
$db[pass] ='your pass';
$db[name] ='ladder';

Should be the same on other config files..hope this helps you out Sonny
_________________
Regards,
Anarchy03
http://anarchy03.us
AnarchyOnline Ent
aappel03@yahoo.com
Back to top View user's profile Send private message Send e-mail Visit poster's website AIM Address
SonnyB
-


Joined: 19 Jun 2003
Posts: 42
Location: New York USA

PostPosted: Mon Jul 14, 2003 5:52 am    Post subject: Heres Example On Your Config. File Reply with quote

Should Look Like So

$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = 'your pass here'; // MySQL password (only needed[/quote]

Also if you changed your privileges and cant get back into PHPMYADMIN Do this

Navigate your way to your abyss web server folder. Go to your phpmyadmin folder.. maybe found under scripts folder. Once in there

Edit this file: config.inc.php with your notebook
on or near 33 lines down you will find code like this

['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = '--Put pass here--';

Put your pass there..then you will beable to access your phpmyadmin file..
Sonny
_________________
Regards,
Anarchy03
http://anarchy03.us
AnarchyOnline Ent
aappel03@yahoo.com
Back to top View user's profile Send private message Send e-mail Visit poster's website AIM Address
pagekeeper
-


Joined: 09 Jul 2003
Posts: 35
Location: London, UK

PostPosted: Mon Jul 14, 2003 11:50 pm    Post subject: Reply with quote

Thanks mate! :D
_________________
Ashley Parmessur - Pagekeeper
Back to top View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    Aprelium Forum Index -> PHP All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB phpBB Group