View previous topic :: View next topic |
Author |
Message |
razorsedge -
Joined: 06 Jan 2007 Posts: 104
|
Posted: Sat Jan 06, 2007 4:54 am Post subject: MySQL 5.0.22 and phpMyAdmin 2.9.1.1 |
|
|
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 |
|
|
Ralph -
Joined: 17 Sep 2006 Posts: 87
|
Posted: Sat Jan 06, 2007 10:21 am Post subject: |
|
|
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 |
|
|
AbyssUnderground -
Joined: 31 Dec 2004 Posts: 3855
|
|
Back to top |
|
|
razorsedge -
Joined: 06 Jan 2007 Posts: 104
|
Posted: Sat Jan 06, 2007 6:12 pm Post subject: |
|
|
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 |
|
|
Ralph -
Joined: 17 Sep 2006 Posts: 87
|
Posted: Sat Jan 06, 2007 6:20 pm Post subject: |
|
|
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 |
|
|
razorsedge -
Joined: 06 Jan 2007 Posts: 104
|
Posted: Sat Jan 06, 2007 11:37 pm Post subject: |
|
|
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 |
|
|
Marty -
Joined: 10 Sep 2006 Posts: 83
|
Posted: Sat Jan 06, 2007 11:53 pm Post subject: |
|
|
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 |
|
|
razorsedge -
Joined: 06 Jan 2007 Posts: 104
|
Posted: Sun Jan 07, 2007 12:17 am Post subject: |
|
|
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 |
|
|
Ralph -
Joined: 17 Sep 2006 Posts: 87
|
Posted: Sun Jan 07, 2007 12:58 am Post subject: |
|
|
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 |
|
|
razorsedge -
Joined: 06 Jan 2007 Posts: 104
|
Posted: Sun Jan 07, 2007 6:10 am Post subject: |
|
|
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 |
|
|
GHOSTRIDER -
Joined: 02 Apr 2007 Posts: 13 Location: New York, NY
|
Posted: Fri Jun 15, 2007 12:40 pm Post subject: |
|
|
.
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 |
|
|
|