I have a reseller hosting account. I created a new account for the actual domain I want the sites to live on (
www.aamembers.org.nz) and have followed my fully documented procedure from the amie.geek.nz site but I cannot recreate a successful installation.
I have asked my host to grant the correct privileges and they confirm it is the same as the amie.geek.nz site. Yet no matter what I do I cannot recreate the same result using exact same instructions. Error is:
Error(1) [1142] query [CREATE OR REPLACE VIEW aamain_users AS SELECT * FROM `aamember_joomla`.`master_users`]. DB Error: CREATE VIEW command denied to user 'aamember_user'@'localhost' for table 'aamain_users' SQL=CREATE OR REPLACE VIEW aamain_users AS SELECT * FROM `aamember_joomla`.`master_users`... etc....etc
The privileges are:
mysql> show privileges;
+-------------------------+---------------------------------------+-------------------------------------------------------+
| Privilege | Context | Comment |
+-------------------------+---------------------------------------+-------------------------------------------------------+
| Alter | Tables | To alter the table |
| Alter routine | Functions,Procedures | To alter or drop stored functions/procedures |
| Create | Databases,Tables,Indexes | To create new databases and tables |
| Create routine | Databases | To use CREATE FUNCTION/PROCEDURE |
| Create temporary tables | Databases | To use CREATE TEMPORARY TABLE |
| Create view | Tables | To create new views |
| Create user | Server Admin | To create new users |
| Delete | Tables | To delete existing rows |
| Drop | Databases,Tables | To drop databases, tables, and views |
| Execute | Functions,Procedures | To execute stored routines |
| File | File access on server | To read and write files on the server |
| Grant option | Databases,Tables,Functions,Procedures | To give to other users those privileges you possess |
| Index | Tables | To create or drop indexes |
| Insert | Tables | To insert data into tables |
| Lock tables | Databases | To use LOCK TABLES (together with SELECT privilege) |
| Process | Server Admin | To view the plain text of currently executing queries |
| References | Databases,Tables | To have references on tables |
| Reload | Server Admin | To reload or refresh tables, logs and privileges |
| Replication client | Server Admin | To ask where the slave or master servers are |
| Replication slave | Server Admin | To read binary log events from the master |
| Select | Tables | To retrieve rows from table |
| Show databases | Server Admin | To see all databases with SHOW DATABASES |
| Show view | Tables | To see views with SHOW CREATE VIEW |
| Shutdown | Server Admin | To shut down the server |
| Super | Server Admin | To use KILL thread, SET GLOBAL, CHANGE MASTER, etc. |
| Update | Tables | To update existing rows |
| Usage | Server Admin | No privileges - allow connect only |
Can you spot anything that might be wrong?
Forum
