Search found 10 matches

by guru13
Wed Sep 24, 2014 11:59 pm
Forum: Web space, mirror & blog services
Topic: Can't Create View in mySQL
Replies: 13
Views: 6154

Re: Can't Create View in mySQL

Hi, I have a mySQL database and I have created tables. However I want to create some views (so I don't have to type in long and tedious queries). However when I enter a CREATE VIEW statement I get back: #1142 - CREATE VIEW command denied to user 'fwdbu9669'@'localhost' for table 'some_v' Can I get ...
by guru13
Wed Sep 24, 2014 11:22 pm
Forum: Web space, mirror & blog services
Topic: Can't Create View in mySQL
Replies: 13
Views: 6154

Re: Can't Create View in mySQL

Hi,

I checked but I still get errors when performing an Export from mydbadmin:

--
-- Structure for view `all_scores_v`
--
DROP TABLE IF EXISTS `all_scores_v`;
-- in use(#1142 - SHOW VIEW command denied to user 'fwdbu9669'@'localhost' for table 'all_scores_v')

Cheers.
by guru13
Tue Sep 23, 2014 11:08 pm
Forum: Web space, mirror & blog services
Topic: Can't Create View in mySQL
Replies: 13
Views: 6154

Re: Can't Create View in mySQL

Hi,

I am trying to backup my mySQL database which contains views however I get the following error for each of my views:

#1142 - SHOW VIEW command denied to user 'fwdbu9669'@'localhost' for table 'some_view'

Can I be granted access to the SHOW VIEW command please?

Thanks.
by guru13
Thu Sep 13, 2012 12:46 am
Forum: Web space, mirror & blog services
Topic: mydbadmin.home.exetel.com.au is very slow
Replies: 3
Views: 3711

mydbadmin.home.exetel.com.au is very slow

Hi, I have noticed that the performance of accessing https://mydbadmin.home.exetel.com.au is really really slow. Given that this is the only way to access and modify MySQL is there anyway it can be looked at? Logging into my MySQL database or clicking on the "SQL" link or clicking on one of the tabl...
by guru13
Wed Aug 29, 2012 2:08 pm
Forum: Web space, mirror & blog services
Topic: Creating Procedures on MySQL
Replies: 5
Views: 3414

Re: Creating Procedures on MySQL

So there is no way I can create storage procedure in mySQL? From what I can tell the CREATE PROCEDURE and CREATE FUNCTION only require the CREATE ROUTINE privilege not super privileges. Hi, I checked this with our sys admins and they have enabled the CREATE ROUTINE privilage to you, therefore could...
by guru13
Tue Aug 28, 2012 12:41 pm
Forum: Web space, mirror & blog services
Topic: Creating Procedures on MySQL
Replies: 5
Views: 3414

Re: Creating Procedures on MySQL

So there is no way I can create storage procedure in mySQL? From what I can tell the CREATE PROCEDURE and CREATE FUNCTION only require the CREATE ROUTINE privilege not super privileges.
by guru13
Tue Aug 28, 2012 1:35 am
Forum: Web space, mirror & blog services
Topic: Creating Procedures on MySQL
Replies: 5
Views: 3414

Creating Procedures on MySQL

Hi,

I'm trying to create some simple procedures on MySQL but when I try to create the procedure I get:

#1044 - Access denied for user 'fwdbu9669'@'localhost' to database 'fwdbd9669'

Am I allowed to create procedures and functions in my MySQL database?

Cheers.
by guru13
Mon Aug 27, 2012 12:15 am
Forum: Web space, mirror & blog services
Topic: Can't Create View in mySQL
Replies: 13
Views: 6154

Re: Can't Create View in mySQL

I have received the email and have sent the reply.
by guru13
Sun Aug 26, 2012 11:45 pm
Forum: Web space, mirror & blog services
Topic: Can't Create View in mySQL
Replies: 13
Views: 6154

Re: Can't Create View in mySQL

HashiniA wrote:Hello Guru,

We have created a ticket for your request as we need few details from your end. Could you please reply back to that email.

Regards,
Hashini
Hi Hashini,

I haven't received any email.

Regards.
by guru13
Sun Aug 26, 2012 10:56 pm
Forum: Web space, mirror & blog services
Topic: Can't Create View in mySQL
Replies: 13
Views: 6154

Can't Create View in mySQL

Hi, I have a mySQL database and I have created tables. However I want to create some views (so I don't have to type in long and tedious queries). However when I enter a CREATE VIEW statement I get back: #1142 - CREATE VIEW command denied to user 'fwdbu9669'@'localhost' for table 'some_v' Can I get p...