Can't Create View in mySQL

Web hosting, FTP/database access, mirror services and hosted blogs

Can't Create View in mySQL

Postby guru13 on 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.
guru13
 
Posts: 10
Joined: Sun Aug 26, 2012 12:53 pm
Location: australia

Re: Can't Create View in mySQL

Postby HashiniA on 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
HashiniA
Exetel Staff
 
Posts: 79
Joined: Wed Jul 07, 2010 9:59 am
Location: Australia

Re: Can't Create View in mySQL

Postby guru13 on Sun Aug 26, 2012 11:45 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
Hi Hashini,

I haven't received any email.

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

Re: Can't Create View in mySQL

Postby kushanw on 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

Postby kushanw on Mon Aug 27, 2012 12:10 am

Hi Guru,

I have resend the email. Please check.
User avatar
kushanw
Exetel Staff
 
Posts: 171
Joined: Sun Jun 03, 2012 5:18 pm
Location: Australia

Re: Can't Create View in mySQL

Postby guru13 on 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

Postby guru13 on 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.
guru13
 
Posts: 10
Joined: Sun Aug 26, 2012 12:53 pm
Location: australia

Re: Can't Create View in mySQL

Postby ShaminG on Tue Sep 23, 2014 11:27 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.
I will have this discussed with our sysadmins and provide you an update.
ShaminG
Exetel Staff
 
Posts: 960
Joined: Wed Jan 06, 2010 10:11 am
Location: Sydney, Australia

Re: Can't Create View in mySQL

Postby shoner on Wed Sep 24, 2014 10:04 am

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
User avatar
shoner
Forum Admin
 
Posts: 753
Joined: Mon Apr 20, 2009 2:50 pm

Re: Can't Create View in mySQL

Postby guru13 on 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.
guru13
 
Posts: 10
Joined: Sun Aug 26, 2012 12:53 pm
Location: australia

Re: Can't Create View in mySQL

Postby LodumS on Wed Sep 24, 2014 11:39 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.
Hi,

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

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

Re: Can't Create View in mySQL

Postby guru13 on Wed Sep 24, 2014 11:59 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.
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'
guru13
 
Posts: 10
Joined: Sun Aug 26, 2012 12:53 pm
Location: australia

Re: Can't Create View in mySQL

Postby LodumS on Thu Sep 25, 2014 12:09 am

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
LodumS
Exetel Staff
 
Posts: 132
Joined: Fri Jun 14, 2013 6:01 pm
Location: Sydney

Re: Can't Create View in mySQL

Postby angelos on Fri Sep 26, 2014 12:56 pm

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?
User avatar
angelos
Exetel Staff
 
Posts: 1068
Joined: Fri Nov 09, 2012 11:22 pm
Location: Australia


Return to “%s” Web space, mirror & blog services

Who is online

Users browsing this forum: No registered users and 2 guests

cron