Little help mabie =)

[Phyzz]

Hey! I have phpwebthings on my server box i am running Windows XP PRO, and i have Mysql,Apache,and PHP installed i go to run phpwebthings/install.php there are no errors or warrnings. i put in my login and password. Then the next page asks what database i want to use. i select it. when i hit next i get..

::You don't have permission to use this database::

But in Mysql i have given the log in full access to everything! i have also tried to just give the account parcial access . or Global with edit ability but still get the same MSG. if you could please help =) any Suggestions?

Thanks again. Phyzz

 

[sleipnir214]

MySQL user credentials are not a 2-tuple of username and password. They are are 3-tuple of username, password, and client IP address.

It's possible that the user+IP to which you gave the permissions is not the same as the user+IP you're trying to use.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[Phyzz]

I am using Mysqlcc . i don't see anything about IP.. it is Localhost should i use an ip in that place instead? is my first time with mysql. i downloaded an updated version and tried again from scratch. and still have the same problem.. mabie i am installing wrong .. but the only way to install is to unzip and hit setup.. =/ i go to

::Http//Localhost/phpwebthings/install.php::

there is Longin: Password: @localhost
i go to the next page and then it asks what database do i want to use. i select the one i want and no mater what one i use it always give sme the same thing.

::You don't have permission to use this database::

mabie a little help =)

thanks again phyzz.

 

[sleipnir214]

I don't know exactly how you are assigning permissions, but if you are using a GRANT query, it's of the form:

GRANT <perms> on <database/table> to <userid>@<host> identified by <password>

I don't know what the default host is if you do not set it.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[Phyzz]

I am usen Mysql Control Center. it is a windows program that i am usen to see the databases and to give acess.. i go to user. i check the box by the data base i want to use. then i check the box under full access and under grant full permition. so not sure what i am doing wrong. if there is a command promped i am supose to use.. i have no clue where it is.. i am not usen a line command. nor do i know how =( first time with Mysql. i read a walk through. now am haven prob's getting it to work =(

mabie if you have a website you like that i might beable to read up on how it works and what programs i should use to interface with it.. that would help me too =) want to learn.

thanks again. phyzz

 

[sleipnir214]

I've never used MySQLCC. But when you are creating a new user, does it ask you for a host?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[Phyzz]

Yes it asks for a host. i put in Localhost . should i be putting in an ip adress instead? or should localhost work?

 

[sleipnir214]

Localhost should work, so long as the username you're using is connecting to MySQL from the same machine on which MySQL is running.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[Phyzz]

hmm i tired useing my ip adress and it gave me this..

::Error connecting: Can't connect to MySQL server on '12.168.254.142' (10060)::

but when i use localhost it takes me to the next section of the install where i chose the database i want to use. but just gives me that crappy you can't use this database.

 

[sleipnir214]

Did you give the userid in question explicit permission to use the database?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[Phyzz]

Ok when i create the user i give him global access and i check all the boxes like:

All Privlages

With grant options.

that is all it gives me.. so i am giving that user all access in witch the MysqlCC is letting me. is ther a command line i can try and where do i put that command line in.. =/

 

[sleipnir214]

MySQLCC should have the capacity for allowing you to execute ad hoc queries. Take a look at my earlier post about GRANT.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[Phyzz]

hmm not sure how to do it.. but i went into query? mabie is not right but only place i could find that would take the line. and i get this

[myserver] ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '<perms> on <database/table> to <userid>@<host> identified by <p

 

[sleipnir214]

First, you need to replace the things inside the triangle brackets (including the brackets themselves) with values appropriate to your application.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[sleipnir214]

Also, for more information on GRANT:

http://www.mysql.com/doc/en/GRANT.html

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[Phyzz]

Thank you i am at work now will look into it when i get home.. thank you for your help =)

 

[Phyzz]

ok i must be doing this wrong or something. because every time i try to grant in query it gives me this error

[myserver] ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'vip66' at line 1

GRANT Super on phyzz to rapture@Localhost identified by ::I put my pass here::

i have tried diffrent ways that the mysql page shows on the table and i have read the page. but still gettin the same error.. mabie you know a better program to use other then MysqlCC.. that i can use to edit. and or mabie i set up the mysql wrong.. not shure how i did that but yeah nevr know hehe =)

thanks again phyzz

 

[sleipnir214]

The SUPER privilege only exists in MySQL in versions 4.0.2 and newer are you running such a version?

Also, my MySQL server will only accept SUPER as a privilege when you use a database/table wildcard:

GRANT SUPER on *.* to foo identified by...

If I use a specific database or table name, MySQL tells me I've tried to perform an illegal GRANT/REVOKE command.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!