MySQL 5.0.22 and phpMyAdmin 2.9.1.1

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


Joined: 06 Jan 2007
Posts: 104

PostPosted: Sat Jan 06, 2007 4:54 am    Post subject: MySQL 5.0.22 and phpMyAdmin 2.9.1.1 Reply with quote

I am using the most up-to-date software. i have followed your tutorials, but everytime i get to the user and password on phpmyadmin and i change it, it comes up with the same error as the old one. when i go into the phpMyAdmin config file and look at the user and password, it only has liek 30 lines... and i have kno clue how to fix this error. Please help me!
the exact error looks liek so
Code:
Error
MySQL said: 

#1045 - Access denied for user 'root'@'localhost' (using password: NO)


and the config file looks like:...
Code:
<?php

/* $Id: config.sample.inc.php 9673 2006-11-03 09:05:54Z nijel $ */
// vim: expandtab sw=4 ts=4 sts=4:

/**
 * phpMyAdmin sample configuration, you can use it as base for
 * manual configuration. For easier setup you can use scripts/setup.php
 *
 * All directives are explained in Documentation.html and on phpMyAdmin
 * wiki <http://wiki.cihar.com>.
 */

/*
 * This is needed for cookie based authentication to encrypt password in
 * cookie
 */
$cfg['blowfish_secret'] = ''; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

/*
 * Servers configuration
 */
$i = 0;

/*
 * First server
 */
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'http://69.69.180.5/phpmyadmin';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysql';
/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pmausr';
$cfg['Servers'][$i]['controlpass'] = 'pmapass';
/* Advanced phpMyAdmin features */
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
$cfg['Servers'][$i]['relation'] = 'pma_relation';
$cfg['Servers'][$i]['table_info'] = 'pma_table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma_column_info';
$cfg['Servers'][$i]['history'] = 'pma_history';

/*
 * End of servers configuration
 */

/*
 * Directories for saving/loading files from server
 */
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

?>

thankyou once again
Back to top View user's profile Send private message
Ralph
-


Joined: 17 Sep 2006
Posts: 87

PostPosted: Sat Jan 06, 2007 10:21 am    Post subject: Reply with quote

razorsedge,

Because of using cookies for the auth_type you might try in your config file, put 'localhost' in for the host and put the word 'root' in for the user and leave the password blank like this ' ' in the config file.

Also put in something, anything for the blowfish_secret!
_________________
My Abyss Websites!
www.qualitynetdesign.com
Back to top View user's profile Send private message Visit poster's website
AbyssUnderground
-


Joined: 31 Dec 2004
Posts: 3855

PostPosted: Sat Jan 06, 2007 12:58 pm    Post subject: Reply with quote

If you're still having problems follow the tutorials on www.abyssunderground.co.uk/tutorials.php
_________________
Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk
Back to top View user's profile Send private message Visit poster's website
razorsedge
-


Joined: 06 Jan 2007
Posts: 104

PostPosted: Sat Jan 06, 2007 6:12 pm    Post subject: Reply with quote

k well i switched to the phpmyadmin 2.8.03 and kept the same mysql. i followed instructions from the tutorial but when i get to the config.inc.php... it looks like the following: well when i past it on here if fixes it... so i have no more problems. but when i opened the file it was a bunch of random stuff togather in like 2 or 3 lines, so what i did is past it on here and then copied it back 2 the text editor and it worked... so thankyou guys. if i have anymore problems i kno where to come[/code]
Back to top View user's profile Send private message
Ralph
-


Joined: 17 Sep 2006
Posts: 87

PostPosted: Sat Jan 06, 2007 6:20 pm    Post subject: Reply with quote

Well, good deal!

Glad you got it working now, it's a nice tool to have for sure.

I actually have the new 2.9.1.1 version on my set up now which was also pretty easy to set up by using the same tutorial from AbyssUnderground...
_________________
My Abyss Websites!
www.qualitynetdesign.com
Back to top View user's profile Send private message Visit poster's website
razorsedge
-


Joined: 06 Jan 2007
Posts: 104

PostPosted: Sat Jan 06, 2007 11:37 pm    Post subject: Reply with quote

k... well i just now finished it and i had to create a script through */phpmyadmin/scripts/setup.php. and when i did so, it said it was having trouble saving so instead of saving it, i downloaded the file itself the i copied and pasted it. but when i go 2 the phpmyadmin site, it says root in the username. is there a way to remove that? cuz i dont want people to kno the username! otherthan that it was simple trial and error. took a while but... for the first time gettin this setup i think i did ok. If anyone else needs help on like a tutorial i mite create one if i get enough pm's sayin make a tutorial. anyways good luck to the noobies like me and anyone that can help me with the username problem please help
Back to top View user's profile Send private message
Marty
-


Joined: 10 Sep 2006
Posts: 83

PostPosted: Sat Jan 06, 2007 11:53 pm    Post subject: Reply with quote

Are you sure your database/mysql is running, check your windows Task Manager for mysqld-nt.exe processes ? if its there its possible that you have a bad log file which is corrupt if you can delete all mysql data log files (not the folders), if your machine won't let you, restart your pc shut down Abyss and shut down the mysql and try to delete it again.

Although its always nice to sort out problems, its really the best way to understand things etc.. but its also an option for you to just protect the directory "phpmyadmin" which basically means you won't have to worry about configuring it, if you decide to do that replace the config files with the originals.

Theres probably a better tutorial somewhere on these forums but heres the basics http://www.aprelium.com/forum/viewtopic.php?t=10212
_________________
www.web-bin.com | www.skydigitalcards.com


Last edited by Marty on Sun Jan 07, 2007 2:02 am; edited 1 time in total
Back to top View user's profile Send private message
razorsedge
-


Joined: 06 Jan 2007
Posts: 104

PostPosted: Sun Jan 07, 2007 12:17 am    Post subject: Reply with quote

k the database is running.... but... when i open up phpMyAdmin on the is shows my username... is there a simple way of deleting it. i looked for a log folder but could not find. for the time beeing, i have the directory username and password protected. Anyways, thanks for the help, and i will prolly create a tutorial for the creating the phpmyadmin 2.9.1.1 file because you have to create it through /phpmyadmin/scripts/setup.php
Back to top View user's profile Send private message
Ralph
-


Joined: 17 Sep 2006
Posts: 87

PostPosted: Sun Jan 07, 2007 12:58 am    Post subject: Reply with quote

razorsedge,

You can log in to phpmyadmin with the user now. Than click on Priviliges and you can make any name you want there. You could have it root@localhost or razorsedge@localhost, just take off the privileges from the one name and make sure you set the new user to have all privileges and than make sure to push the apply or Go button before you leave so that it sets the new name.
_________________
My Abyss Websites!
www.qualitynetdesign.com
Back to top View user's profile Send private message Visit poster's website
razorsedge
-


Joined: 06 Jan 2007
Posts: 104

PostPosted: Sun Jan 07, 2007 6:10 am    Post subject: Reply with quote

i have it fixed now .... it was showing the username on my server but when i went to a friends house, it did not show the username, but thankyou for the help!. anyways you can look at my site at:
http://69.69.180.5/
this is our old website, i am workin on a new one and it will have 2 websites within it. anyways it will be designed in flash and have 2 forums in it. some of the pages will be locked out for only my fraternity. otherthan that, i think it will be a cool design. if you want, the admin can now close this issue. thanks for all the help everyone
Back to top View user's profile Send private message
GHOSTRIDER
-


Joined: 02 Apr 2007
Posts: 13
Location: New York, NY

PostPosted: Fri Jun 15, 2007 12:40 pm    Post subject: Reply with quote

.

Or...

You could save yourself a lot of aggravation and
totally ignore all of the complications
associated with this rediculous phpmyadmin thing...
:roll:

and install the MySQL Tools package designed by the database
developer.

A much, much better way of managing MySQL than
phpmyadmin could ever dream of being.

MySQL Admin. can also be accessed through TCP
if you config it that way..

You can review the tools HERE

And download them HERE

Good Luck,

GHOSTRIDER
_________________
Back to top View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    Aprelium Forum Index -> Databases 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