Mysql permisiong problem.

[chetanmadaan]

I am using Joomla and a script within it.

That Script is suppose to copy tables from one DB to another.


Error(1) [1142] query [CREATE OR REPLACE VIEW test_users AS SELECT * FROM `localiz_master`.`jos_users`]. DB Error: CREATE VIEW command denied to user 'localiz_master'@'localhost' for table 'test_users' SQL=CREATE OR REPLACE VIEW test_users AS SELECT * FROM `localiz_master`.`jos_users`


Error [1142] retrying query [CREATE OR REPLACE VIEW test_users AS SELECT * FROM `localiz_master`.`jos_users`]. DB Error: CREATE VIEW command denied to user 'localiz_master'@'localhost' for table 'test_users' SQL=CREATE OR REPLACE VIEW test_users AS SELECT * FROM `localiz_master`.`jos_users`


localiz_master: name of the DB from which data is suppose to be copied.
jos_users: name of the table form the main DB.
localiz_master: user for the DB.
localhost: host
test_users: name of the table to be created.

we do have phpmyadmin but the user's table is hidden. can someone please tell us the SSH command we might run to make localiz_master user have access to all the databases.

thanks in advance DD. you have been great helping me out of problems!

[james438]

I do not have joomla and may not be able to help much here. Here are a few important questions though: What is the code that you are using to access your database? Are you sure that you are using the correct DB name and user name and password, etc? Did you used to have access to your database and now do not or is this a new database? What do you mean you do not have access to the table in phpmyadmin? That seems a bit unusual.

There are also ways around this as well. You can export your database tables via phpmyadmin or you can write a php script to do what you are proposing.


The most likely problem is that either your username or password for accessing the database is incorrect. Look into these and see if they are correct. I tried recreating your problem and when the username or password were incorrect I got nearly the same error.

[chetanmadaan]

James,

script is designed in such a way... so that if the username password is incorrect... it should give another error.

but in this one it's giving the permissions.

well, in any manner the question is same... how can i grant permissions for mysql users via ssh.

[james438]

sorry, beyond those questions I asked and the possible solution I proposed I can't help you further as I do not have ssh or joomla and am unfamiliar with them. I hope someone else will be able to provide a better answer.

[mynest]

Hi, nice to meet you guys!!

[chetanmadaan]

ALRIGHT... GUYS here is the info: http://www.linuxquestions.org/questions/showthread.php?p=4002901#post4002901

but i still love DD more than any forum.