Access Denied

skyhigh007 · November 12th, 2007, 3:14 PM

Hi

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ODBC'

'localhost' (using password: NO)

is ODBC the Root user in localhost ?

skyhigh007 · November 13th, 2007, 1:46 AM

Access denied for user 'ahzhou'

'localhost' (using password: NO) ? How can i change to using password yes ?

**Roxy** · November 13th, 2007, 1:49 AM

Did you create a database username with ODBC? localhost is your "root".

skyhigh007 · November 14th, 2007, 1:53 AM

I didn't create ODBC as a username.

wgm · November 14th, 2007, 2:04 AM

Database isn't setup properly.

Is this what you did...

1. Create database (name of database)

2. Create user (name of database above and password, same password that was given in the welcome email)

3. Add user to database

skyhigh007 · November 14th, 2007, 2:47 PM

1. I created a database. Ex: Shoe
2. User: A user name with password. Ex: user= person, Password= cart
3. Added the user to the database

**Roxy** · November 14th, 2007, 5:11 PM

Okay, I'm not sure if this works for all users under surpass, but when I create a database I have to use my login as part of my database name and user name. Here is what it would look like if I used what info you gave...

Login is: kentel
Host: localhost
Database name: kentel_shoe
DB Username: kentel_person
Password: cart

Got it? This is the information that you would write out in whatever script your trying to work with. BTW: Kentel isn't my real login name. =)

skyhigh007 · November 15th, 2007, 4:43 PM

If i just created a user and a database, how would I know if the user i just created has same privileges as the root user ?

skyhigh007 · November 15th, 2007, 4:46 PM

For host name: should i type in "localhost or the IP/Web address of your server?

November 12th, 2007, 3:14 PM	#1 (permalink)
skyhigh007 Registered User Seasoned Poster Joined in Jun 2005 99 posts Gave thanks: 0 Thanked 0 times	Access Denied Hi Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ODBC''localhost' (using password: NO) is ODBC the Root user in localhost ?

November 13th, 2007, 1:46 AM	#2 (permalink)
skyhigh007 Registered User Seasoned Poster Joined in Jun 2005 99 posts Gave thanks: 0 Thanked 0 times	Access denied for user 'ahzhou''localhost' (using password: NO) ? How can i change to using password yes ?

November 13th, 2007, 1:49 AM	#3 (permalink)
Roxy URB4N 5K1LLZ Super #1 Joined in Sep 2005 Lives in Orlando, FL Hosted on SH63 2,660 posts Gave thanks: 81 Thanked 128 times	Did you create a database username with ODBC? localhost is your "root". __________________ Roxanne Urban Roxy -Personal Blog SH63 - the best darn shared server!

November 14th, 2007, 5:11 PM	#7 (permalink)
Roxy URB4N 5K1LLZ Super #1 Joined in Sep 2005 Lives in Orlando, FL Hosted on SH63 2,660 posts Gave thanks: 81 Thanked 128 times	Okay, I'm not sure if this works for all users under surpass, but when I create a database I have to use my login as part of my database name and user name. Here is what it would look like if I used what info you gave... Login is: kentel Host: localhost Database name: kentel_shoe DB Username: kentel_person Password: cart Got it? This is the information that you would write out in whatever script your trying to work with. BTW: Kentel isn't my real login name. =) __________________ Roxanne Urban Roxy -Personal Blog SH63 - the best darn shared server!

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

November 14th, 2007, 1:53 AM	#4 (permalink)
skyhigh007 Registered User Seasoned Poster Joined in Jun 2005 99 posts Gave thanks: 0 Thanked 0 times	I didn't create ODBC as a username.

November 14th, 2007, 2:04 AM	#5 (permalink)
wgm Registered User Super #1 Joined in Mar 2005 Lives in Washougal, WA 1,306 posts Gave thanks: 23 Thanked 39 times	Database isn't setup properly. Is this what you did... 1. Create database (name of database) 2. Create user (name of database above and password, same password that was given in the welcome email) 3. Add user to database

November 14th, 2007, 2:47 PM	#6 (permalink)
skyhigh007 Registered User Seasoned Poster Joined in Jun 2005 99 posts Gave thanks: 0 Thanked 0 times	1. I created a database. Ex: Shoe 2. User: A user name with password. Ex: user= person, Password= cart 3. Added the user to the database

November 15th, 2007, 4:43 PM	#8 (permalink)
skyhigh007 Registered User Seasoned Poster Joined in Jun 2005 99 posts Gave thanks: 0 Thanked 0 times	If i just created a user and a database, how would I know if the user i just created has same privileges as the root user ?

November 15th, 2007, 4:46 PM	#9 (permalink)
skyhigh007 Registered User Seasoned Poster Joined in Jun 2005 99 posts Gave thanks: 0 Thanked 0 times	For host name: should i type in "localhost or the IP/Web address of your server?

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)