mysql Create Function Access Denied

Web hosting, FTP/database access, mirror services and hosted blogs
Post Reply
squeakytown
Posts: 132
Joined: Thu May 26, 2005 1:10 pm

mysql Create Function Access Denied

Post by squeakytown » Sun Mar 03, 2019 2:11 pm

Hi,

Can you please grant access to create functions under our free website and the paid website mysql DB's?

Thanks
Dave
SSLSC

IsuruB
Exetel Staff
Posts: 222
Joined: Thu Sep 08, 2016 10:18 pm
Location: Sydney

Re: mysql Create Function Access Denied

Post by IsuruB » Sun Mar 03, 2019 3:13 pm

squeakytown wrote:
Sun Mar 03, 2019 2:11 pm
Hi,

Can you please grant access to create functions under our free website and the paid website mysql DB's?

Thanks
Dave
SSLSC
Thanks for reaching out. The reference number for your inquiry is 14431045. We will check with the Exetel System Administrators and get back to you shortly with a response.

squeakytown
Posts: 132
Joined: Thu May 26, 2005 1:10 pm

Re: mysql Create Function Access Denied

Post by squeakytown » Sat Mar 09, 2019 11:29 am

Hi,

Can i have an update on this ticket thanks (create function access is still denied).

Dave

judep
Exetel Staff
Posts: 266
Joined: Thu Jan 04, 2018 1:57 pm
Location: Sri Lanka

Re: mysql Create Function Access Denied

Post by judep » Sat Mar 09, 2019 5:16 pm

squeakytown wrote:
Sun Mar 03, 2019 2:11 pm
Hi,

Can you please grant access to create functions under our free website and the paid website mysql DB's?

Thanks
Dave
SSLSC
Hi

Our system administrators advised that you are able to create within your database however are not able to create new database.

squeakytown
Posts: 132
Joined: Thu May 26, 2005 1:10 pm

Re: mysql Create Function Access Denied

Post by squeakytown » Sun Mar 10, 2019 11:14 am

Hi,

If I have access, can you please advise the reason for this error?

Error
SQL query: Documentation

Create Function NextBibNo(fSwimDate Date, fCatg VARCHAR(5)) RETURNS INT(8) ....

MySQL said: Documentation

#1044 - Access denied for user 'fwdbuXXXXX'@'localhost' to database 'fwdbdXXXXX'

(Full Message PMed to you).
Thanks
Dave

IsuruB
Exetel Staff
Posts: 222
Joined: Thu Sep 08, 2016 10:18 pm
Location: Sydney

Re: mysql Create Function Access Denied

Post by IsuruB » Sun Mar 10, 2019 1:17 pm

squeakytown wrote:
Sun Mar 10, 2019 11:14 am
Hi,

If I have access, can you please advise the reason for this error?

Error
SQL query: Documentation

Create Function NextBibNo(fSwimDate Date, fCatg VARCHAR(5)) RETURNS INT(8) ....

MySQL said: Documentation

#1044 - Access denied for user 'fwdbuXXXXX'@'localhost' to database 'fwdbdXXXXX'

(Full Message PMed to you).
Thanks
Dave
We have passed this on to the System Administrators once more. Kindly await further updates

himarshaj
Exetel Staff
Posts: 83
Joined: Wed Nov 07, 2018 6:09 pm

Re: mysql Create Function Access Denied

Post by himarshaj » Tue Mar 12, 2019 11:08 pm

Please be advised that the Exetel System Administrators have investigated your inquiry and we have sent you an email in regards to the outcome (Reference - 14431045). Please follow the instructions and get back to our Hosting team directly.

squeakytown
Posts: 132
Joined: Thu May 26, 2005 1:10 pm

Re: mysql Create Function Access Denied

Post by squeakytown » Sat Mar 23, 2019 11:23 am

Hi,

For those who may require this in the future.

Under the Exetel Free Website area you cannot create your own database functions.

You must email the function to hosting@exetel.com.au for them to create.
Please ensure you stipulate you need execute access to the new function.
Exetel has some issue being able to grant execute access.

Dave

Post Reply