Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 access denied

Author  Topic 

fuzzalicious
Starting Member

3 Posts

Posted - 2007-12-10 : 18:47:41
i made a database in phpmyadmin, and used all information given by the service provided, but i can't grant access do my user.'

i can alter and change my database from phpmyadmin, but when i try a command like "grant select on database.table_name to 'user'@'%';" to be able to view the table from a website, i get "#1142 - SELECT,GRANT command denied to user 'xxx'@'xxx.xxx.net' for table 'xxx'"

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-12-10 : 18:54:46
If you are administering a MySQL database, maybe you should turn to www.dbforums.com or www.mysql.com for answers.
This is a MICROSOFT SQL SERVER forum.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

fuzzalicious
Starting Member

3 Posts

Posted - 2007-12-10 : 18:54:57
if i try a "identified by" i get "#1132 - You must have privileges to update tables in the mysql database to be able to change passwords for others"
Go to Top of Page

fuzzalicious
Starting Member

3 Posts

Posted - 2007-12-10 : 18:55:47
oki
Go to Top of Page
   

- Advertisement -