|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
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. |
|
#2
|
|||
|
|||
|
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. |
![]() |
| Viewing: Dev Articles Community Forums > Databases > General SQL Development > lock table ... access denied...? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|