General SQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsDatabasesGeneral SQL Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old March 10th, 2003, 12:21 AM
shanor shanor is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Mar 2003
Posts: 2 shanor User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
lock table ... access denied...?

well here is the query im tring to execute:
lock tables CompanyTable write;
select * from CompanyTable;
unlock tables;

and here is what i get on quering the first line:
Query test1 is Invalid: Access denied for user: '@127.0.0.1' to database 'tkysh'

i gave myself all the permission to this database by using
GRANT all ON tkysh.* TO USER@'127.0.0.1';

but same results...
any one have any idea?
thnx in advanced
Shanor.

Reply With Quote
  #2  
Old March 10th, 2003, 12:59 AM
shanor shanor is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Mar 2003
Posts: 2 shanor User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
OK solved it.

i know i was missing something the only problem was to find out exactly what is it that im missing....
welll here it is...since im running everything on my own computer, both the apache and the mysql for testing porpuses, i was loggin in to the mysql database with no user name... apperently as i found out loggin with empty user name will work just fine in most cases but won't lock tables..... so by loggin in as ROOT or by defining a new user for the database and logging in using that database was it and my unwilling to lock table, agreed to be locked and unlocked.....
hope that this will help someone in the future.

Shanor.

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesGeneral SQL Development > lock table ... access denied...?


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway