Can't Create View in mySQL

Web hosting, FTP/database access, mirror services and hosted blogs
Post Reply
guru13
Posts: 10
Joined: Sun Aug 26, 2012 12:53 pm
Location: australia

Can't Create View in mySQL

Post by guru13 » Sun Aug 26, 2012 10:56 pm

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 permissions to create Views?

Thanks.

HashiniA
Exetel Staff
Posts: 79
Joined: Wed Jul 07, 2010 9:59 am
Location: Australia

Re: Can't Create View in mySQL

Post by HashiniA » Sun Aug 26, 2012 11:32 pm

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

guru13
Posts: 10
Joined: Sun Aug 26, 2012 12:53 pm
Location: australia

Re: Can't Create View in mySQL

Post by guru13 » Sun Aug 26, 2012 11:45 pm

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.

User avatar
kushanw
Exetel Staff
Posts: 171
Joined: Sun Jun 03, 2012 5:18 pm
Location: Australia

Re: Can't Create View in mySQL

Post by kushanw » Sun Aug 26, 2012 11:51 pm

Hi Guru,

We have sent you an email with the ticket reference 5543771 to the nominated email address given in your account. If you did not receive this email, please PM me your correct email address.

User avatar
kushanw
Exetel Staff
Posts: 171
Joined: Sun Jun 03, 2012 5:18 pm
Location: Australia

Re: Can't Create View in mySQL

Post by kushanw » Mon Aug 27, 2012 12:10 am

Hi Guru,

I have resend the email. Please check.

guru13
Posts: 10
Joined: Sun Aug 26, 2012 12:53 pm
Location: australia

Re: Can't Create View in mySQL

Post by guru13 » Mon Aug 27, 2012 12:15 am

I have received the email and have sent the reply.

guru13
Posts: 10
Joined: Sun Aug 26, 2012 12:53 pm
Location: australia

Re: Can't Create View in mySQL

Post by guru13 » Tue Sep 23, 2014 11:08 pm

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.

ShaminG
Exetel Staff
Posts: 960
Joined: Wed Jan 06, 2010 10:11 am
Location: Sydney, Australia

Re: Can't Create View in mySQL

Post by ShaminG » Tue Sep 23, 2014 11:27 pm

guru13 wrote: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.
I will have this discussed with our sysadmins and provide you an update.

User avatar
shoner
Forum Admin
Posts: 756
Joined: Mon Apr 20, 2009 2:50 pm

Re: Can't Create View in mySQL

Post by shoner » Wed Sep 24, 2014 10:04 am

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

Thanks.
This has now been fixed. Can you please check and confirm.
"Helping Making a Better World"

Log a fault ticket Here
or call Exetel VOIP numbers (02) 8030 1000 or 1300 788 141 (log faults 24x7)
Exetel Support Portal

guru13
Posts: 10
Joined: Sun Aug 26, 2012 12:53 pm
Location: australia

Re: Can't Create View in mySQL

Post by guru13 » Wed Sep 24, 2014 11:22 pm

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.

User avatar
LodumS
Exetel Staff
Posts: 132
Joined: Fri Jun 14, 2013 6:01 pm
Location: Sydney

Re: Can't Create View in mySQL

Post by LodumS » Wed Sep 24, 2014 11:39 pm

guru13 wrote: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 permissions to create Views?

Thanks.
Hi,

We will advise our system engineers to further investigate this issue.

Regards

guru13
Posts: 10
Joined: Sun Aug 26, 2012 12:53 pm
Location: australia

Re: Can't Create View in mySQL

Post by guru13 » Wed Sep 24, 2014 11:59 pm

LodumS wrote:
guru13 wrote: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 permissions to create Views?

Thanks.
Hi,

We will advise our system engineers to further investigate this issue.

Regards
That is not the issue, I can create views. The issue I get is as below:

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

User avatar
LodumS
Exetel Staff
Posts: 132
Joined: Fri Jun 14, 2013 6:01 pm
Location: Sydney

Re: Can't Create View in mySQL

Post by LodumS » Thu Sep 25, 2014 12:09 am

guru13 wrote: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 permissions to create Views?

Thanks.
Hi,

Sorry about that, I have quoted the wrong post.

Any way we have forwarded the correct error message to our system engineers. We will update you soon.

Regards

User avatar
angelos
Exetel Staff
Posts: 1068
Joined: Fri Nov 09, 2012 11:22 pm
Location: Australia

Re: Can't Create View in mySQL

Post by angelos » Fri Sep 26, 2014 12:56 pm

LodumS wrote: Any way we have forwarded the correct error message to our system engineers. We will update you soon.
Could you try again and let us know how it goes?

Post Reply