Quote:
Originally Posted by chetanmadaan
I am using Joomla and a script within it.
That Script is suppose to copy tables from one DB to another.
Code:
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.
|
ok..first you have to connect to you local database.
i have no idea what kind of permissions localiz_master has one thing is that you will need to use an admin user to assign this user the correct permissions.
you will need something like this,
first connect to myqsl server wherever it maybe.
Code:
mysql -h hostname -U user -ppassword
-------
Code:
GRANT CREATE VIEW TO 'localiz_master'@'hostname' IDENTIFIED BY 'password';
flush privileges;
There may even be more privileges you need to assign....not sure...but if you do, you can assign them all in one go.
If that particular user cannot create views, im pretty sure there are alot of other things that the user cannot do.
Code:
select * from user where User='username';
setting any of these options from N to Y also enables this user access for this certain privilege.