Pages: 123Next
Current Page: 1 of 3
Access denied for user 'root'@'localhost' (using password: YES
Posted by: devarmagan (124.43.232.---)
Date: February 11, 2007 03:24PM

i have install the wamp and running now i put a php system folder into WWW root and its coming under topic of YOUR PROJECTS and when i try to install that system i am getting a error msg the msg is "Warning: mysql_get_server_info(): supplied argument is not a valid MySQL-Link resource in C:\wamp\www\shopping\includes\database\mysql.php on line 14
Access denied for user 'root'@'localhost' (using password: YES)"

and iam getting another error msg for anothor system " Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request"


please help

Options: ReplyQuote
Re: Access denied for user 'root'@'localhost' (using password: YES
Posted by: CyberSpatium (71.237.217.---)
Date: February 11, 2007 05:15PM

post your code.



CyberSpatium
WAMP English Forum Admin
--------------------------------------

like my free support? help support me by checking out my new Newbie Webmaster Development Forum dedicated to the newbie webmaster here:
www.WebDevNewbie.com

Options: ReplyQuote
Re: Access denied for user 'root'@'localhost' (using password: YES
Posted by: yfastud (---.accel.atl.earthlink.net)
Date: February 11, 2007 05:22PM

Create user's db, username, and password before installing and you should be fine.

Have fun

[www.jlbn.com] (testing web server)
[test.jlbn.com] (testing codes)
[forum.jlbn.com] (testing phpBB2)
[forums.jlbn.com] (testing phpBB3)
[mail.jlbn.com] (testing mailserver)
[ftp.jlbn.com] (testing ftp server)
[www.jlbn.com] (testing flashes)
[www.jlbn.com] (testing images)
[joomla.jlbn.com] (testing Joomla 1.0.10)
[fusion.jlbn.com] (testing phpFusion 6.01.6)
[nuke.jlbn.com] (testing phpNuke 7.9)
[nukep.jlbn.com] (testing phpNuke Platinum 7.6.b.4v2)
[pnuke.jlbn.com] (testing PostNuke 0.800-MS2)
[nukevo.jlbn.com] (testing phpNuke Evolution 2.0.1)

Options: ReplyQuote
Re: Access denied for user 'root'@'localhost' (using password: YES
Posted by: devarmagan (124.43.232.---)
Date: February 11, 2007 06:49PM

the code is here

<?php

// database functions :: MySQL

function db_connect($host,$user,$pass) //create connection
{
$r = mysql_connect($host,$user,$pass);
if(preg_match('/^5\./',mysql_get_server_info($r)))db_query('SET SESSION sql_mode=0');
return $r;
}

function db_select_db($name) //select database
{
return mysql_select_db($name);
}

function db_query($s) //database query
{
return mysql_query($s);
}

function db_fetch_row($q) //row fetching
{
return mysql_fetch_row($q);
}

function db_insert_id()
{
return mysql_insert_id();
}

function db_error() //database error message
{
return mysql_error();
}

?>





the errors are in thesetwo lines
$r = mysql_connect($host,$user,$pass);
if(preg_match('/^5\./',mysql_get_server_info($r)))db_query('SET SESSION


becose iam getting 2 error msg

Options: ReplyQuote
Re: Access denied for user 'root'@'localhost' (using password: YES
Posted by: devarmagan (124.43.232.---)
Date: February 11, 2007 06:54PM

yfastud wrote:

> Create user's db, username, and password before installing and
> you should be fine.
>
Evolution 2.0.1)[/i]


ok i have created a user name call ragu and gave the pass word ragu and create the database call ragu too what next , is there any changes have to made in the script code

Options: ReplyQuote
Re: Access denied for user 'root'@'localhost' (using password: YES
Posted by: CyberSpatium (71.237.217.---)
Date: February 12, 2007 01:10AM

once you add your new user, pass, and database to your script do you still get any errors?


CyberSpatium
WAMP English Forum Admin
--------------------------------------

like my free support? help support me by checking out my new Newbie Webmaster Development Forum dedicated to the newbie webmaster here:
www.WebDevNewbie.com

Options: ReplyQuote
Re: Access denied for user 'root'@'localhost' (using password: YES
Posted by: devarmagan (124.43.235.---)
Date: February 17, 2007 11:59AM

yes still iam getting

Options: ReplyQuote
Re: Access denied for user 'root'@'localhost' (using password: YES
Posted by: yfastud (---.mia.bellsouth.net)
Date: February 17, 2007 04:45PM

What apps do you try to install?

Have fun

[www.jlbn.com] (testing web server)
[test.jlbn.com] (testing codes)
[forum.jlbn.com] (testing phpBB2)
[forums.jlbn.com] (testing phpBB3)
[mail.jlbn.com] (testing mailserver)
[ftp.jlbn.com] (testing ftp server)
[www.jlbn.com] (testing flashes)
[www.jlbn.com] (testing images)
[joomla.jlbn.com] (testing Joomla 1.0.10)
[fusion.jlbn.com] (testing phpFusion 6.01.6)
[nuke.jlbn.com] (testing phpNuke 7.9)
[nukep.jlbn.com] (testing phpNuke Platinum 7.6.b.4v2)
[pnuke.jlbn.com] (testing PostNuke 0.800-MS2)
[nukevo.jlbn.com] (testing phpNuke Evolution 2.0.1)
[wp.jlbn.com] (testing WordPress 2.1)
[ws.jlbn.com] (testing WebSpell 4.01.02)

Options: ReplyQuote
Re: Access denied for user 'root'@'localhost' (using password: YES
Posted by: devarmagan (124.43.235.---)
Date: February 17, 2007 06:07PM

its a free tender system and shopping system

Options: ReplyQuote
Re: Access denied for user 'root'@'localhost' (using password: YES
Posted by: yfastud (---.mia.bellsouth.net)
Date: February 17, 2007 06:22PM

Don't mind if provide its real name, and if it's free, I will install it and let you know the outcome.

Have fun

[www.jlbn.com] (testing web server)
[test.jlbn.com] (testing codes)
[forum.jlbn.com] (testing phpBB2)
[forums.jlbn.com] (testing phpBB3)
[mail.jlbn.com] (testing mailserver)
[ftp.jlbn.com] (testing ftp server)
[www.jlbn.com] (testing flashes)
[www.jlbn.com] (testing images)
[joomla.jlbn.com] (testing Joomla 1.0.10)
[fusion.jlbn.com] (testing phpFusion 6.01.6)
[nuke.jlbn.com] (testing phpNuke 7.9)
[nukep.jlbn.com] (testing phpNuke Platinum 7.6.b.4v2)
[pnuke.jlbn.com] (testing PostNuke 0.800-MS2)
[nukevo.jlbn.com] (testing phpNuke Evolution 2.0.1)
[wp.jlbn.com] (testing WordPress 2.1)
[ws.jlbn.com] (testing WebSpell 4.01.02)

Options: ReplyQuote
Re: Access denied for user 'root'@'localhost' (using password: YES
Posted by: devarmagan (124.43.235.---)
Date: February 17, 2007 06:39PM

[www.shop-script.com], [www.tendersystem.com], [phpwebsite.appstate.edu], its giving errors for all systems

Options: ReplyQuote
Re: Access denied for user 'root'@'localhost' (using password: YES
Posted by: yfastud (---.mia.bellsouth.net)
Date: February 18, 2007 07:58PM

Except phpwebsite needs pear which is what I dont like to install in my system, you have to setup db account, including db, username, and password, also some settings as listed below for the others before installing

ShopScript:
file_uploads
magic_quotes_gpc

TenderSystem:
php_xsl
php_curl

ShoptScript screen:
[i117.photobucket.com]

TenderSystem screen:
[i117.photobucket.com]

Have fun

[www.jlbn.com] (testing web server)
[test.jlbn.com] (testing codes)
[forum.jlbn.com] (testing phpBB2)
[forums.jlbn.com] (testing phpBB3)
[mail.jlbn.com] (testing mailserver)
[ftp.jlbn.com] (testing ftp server)
[www.jlbn.com] (testing flashes)
[www.jlbn.com] (testing images)
[joomla.jlbn.com] (testing Joomla 1.0.10)
[fusion.jlbn.com] (testing phpFusion 6.01.6)
[nuke.jlbn.com] (testing phpNuke 7.9)
[nukep.jlbn.com] (testing phpNuke Platinum 7.6.b.4v2)
[pnuke.jlbn.com] (testing PostNuke 0.800-MS2)
[nukevo.jlbn.com] (testing phpNuke Evolution 2.0.1)
[wp.jlbn.com] (testing WordPress 2.1)
[ws.jlbn.com] (testing WebSpell 4.01.02)

Options: ReplyQuote
Re: Access denied for user 'root'@'localhost' (using password: YES
Posted by: devarmagan (124.43.230.---)
Date: February 18, 2007 08:20PM

to the shop script from which directry you got the sql

Options: ReplyQuote
Re: Access denied for user 'root'@'localhost' (using password: YES
Posted by: devarmagan (124.43.230.---)
Date: February 18, 2007 08:48PM

to the shopping iam getting this error

Fatal error: Call to undefined function mysql_connect() in c:\webs\test\shopping\includes\database\mysql.php on line 13

Options: ReplyQuote
Re: Access denied for user 'root'@'localhost' (using password: YES
Posted by: yfastud (---.cable.mindspring.com)
Date: February 19, 2007 04:12AM

while or after installation?

Have fun

[www.jlbn.com] (testing web server)
[test.jlbn.com] (testing codes)
[forum.jlbn.com] (testing phpBB2)
[forums.jlbn.com] (testing phpBB3)
[mail.jlbn.com] (testing mailserver)
[ftp.jlbn.com] (testing ftp server)
[www.jlbn.com] (testing flashes)
[www.jlbn.com] (testing images)
[joomla.jlbn.com] (testing Joomla 1.0.10)
[fusion.jlbn.com] (testing phpFusion 6.01.6)
[nuke.jlbn.com] (testing phpNuke 7.9)
[nukep.jlbn.com] (testing phpNuke Platinum 7.6.b.4v2)
[pnuke.jlbn.com] (testing PostNuke 0.800-MS2)
[nukevo.jlbn.com] (testing phpNuke Evolution 2.0.1)
[wp.jlbn.com] (testing WordPress 2.1)
[ws.jlbn.com] (testing WebSpell 4.01.02)

Options: ReplyQuote
Re: Access denied for user 'root'@'localhost' (using password: YES
Posted by: devarmagan (124.43.236.---)
Date: February 19, 2007 04:54AM

after installation , from where u got the sql ?

Options: ReplyQuote
Re: Access denied for user 'root'@'localhost' (using password: YES
Posted by: yfastud (---.cable.mindspring.com)
Date: February 19, 2007 06:07AM

Tell me what you are you trying to do. I try it and let you know, but dont ask me where is db because it should be as your setup. For example

host: localhost
db: shopscript
user: shopscript
pass: ****

Have fun

[www.jlbn.com] (testing web server)
[test.jlbn.com] (testing codes)
[forum.jlbn.com] (testing phpBB2)
[forums.jlbn.com] (testing phpBB3)
[mail.jlbn.com] (testing mailserver)
[ftp.jlbn.com] (testing ftp server)
[www.jlbn.com] (testing flashes)
[www.jlbn.com] (testing images)
[joomla.jlbn.com] (testing Joomla 1.0.10)
[fusion.jlbn.com] (testing phpFusion 6.01.6)
[nuke.jlbn.com] (testing phpNuke 7.9)
[nukep.jlbn.com] (testing phpNuke Platinum 7.6.b.4v2)
[pnuke.jlbn.com] (testing PostNuke 0.800-MS2)
[nukevo.jlbn.com] (testing phpNuke Evolution 2.0.1)
[wp.jlbn.com] (testing WordPress 2.1)
[ws.jlbn.com] (testing WebSpell 4.01.02)

Options: ReplyQuote
Re: Access denied for user 'root'@'localhost' (using password: YES
Posted by: devarmagan (124.43.236.---)
Date: February 19, 2007 06:36AM

no i asked the where is the sql code in that directory,
now i want to install to my local machine , is i have to create a new user in database for every new system or i have user name call root so far i have worked only in root

Options: ReplyQuote
Re: Access denied for user 'root'@'localhost' (using password: YES
Posted by: yfastud (72.236.169.---)
Date: February 19, 2007 01:33PM

First thing first, for own security, I've never use root, god admin user, who can change everything and any thing in mysql. Second, already mentioned, for each new user, and treated new app as new user, I've created new mysql account including db, username, and password w/ limited usage so that user can NOT see or use any other db but only on specific assigned db.

Have fun

[www.jlbn.com] (testing web server)
[test.jlbn.com] (testing codes)
[forum.jlbn.com] (testing phpBB2)
[forums.jlbn.com] (testing phpBB3)
[mail.jlbn.com] (testing mailserver)
[ftp.jlbn.com] (testing ftp server)
[www.jlbn.com] (testing flashes)
[www.jlbn.com] (testing images)
[joomla.jlbn.com] (testing Joomla 1.0.10)
[fusion.jlbn.com] (testing phpFusion 6.01.6)
[nuke.jlbn.com] (testing phpNuke 7.9)
[nukep.jlbn.com] (testing phpNuke Platinum 7.6.b.4v2)
[pnuke.jlbn.com] (testing PostNuke 0.800-MS2)
[nukevo.jlbn.com] (testing phpNuke Evolution 2.0.1)
[wp.jlbn.com] (testing WordPress 2.1)
[ws.jlbn.com] (testing WebSpell 4.01.02)



Post Edited (02-19-07 16:00)

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Options: ReplyQuote
Re: Access denied for user 'root'@'localhost' (using password: YES
Posted by: devarmagan (124.43.234.---)
Date: February 19, 2007 03:26PM

ok wheres the sql file?

Options: ReplyQuote
Pages: 123Next
Current Page: 1 of 3


Sorry, only registered users may post in this forum.