Unable To Create Mysql Stored Procedures |
||
Welcome to the Zymic webmaster forums. Our forums are here to provide people the free ability to discuss a range of websites related topics such as design, development coding and marketing.
In order to post you will need to register for a zymic account or if you already have one simply login by using the form on the left.
Zymic Webmaster Forums Zymic Free Web Hosting Databases & MySQL |
||
![]() |
Unable To Create Mysql Stored Procedures |
||
Jun 23 2011, 04:43 PM
Post
#1
|
|
|
Newbie ![]() Group: Members Posts: 3 Joined: 22-June 11 Member No.: 195,243 |
I'm trying to create stored procedures in MySQL using the MySQL buddy interface Zymic provides. It tells me access is denied. I've looked on the forum and the only advice is to go to IRC, so I have, but nobody responds to my question. Any help is appreciated. Thanks.
|
|
|
Jun 23 2011, 05:18 PM
Post
#2
|
|
|
THE SILENT FORUM NINJA ![]() ![]() ![]() ![]() ![]() ![]() ![]() Group: Administrators Posts: 3,758 Joined: 23-January 10 From: on your screen Member No.: 127,507 |
Please go to http://mysqlquery.zymichost.com/connectionchecker.php to check if you have set up your database correctly and if you get any errors let us know
|
|
|
Jun 23 2011, 07:22 PM
Post
#3
|
|
|
Newbie ![]() Group: Members Posts: 3 Joined: 22-June 11 Member No.: 195,243 |
It appears to be correct...
SUCCESS! Your details are correct. While in SQL Buddy I can run DML and DDL with the exception of creating stored procedures. Thanks! |
|
|
Jun 23 2011, 08:18 PM
Post
#4
|
|
|
Newbie ![]() Group: Members Posts: 13 Joined: 21-April 11 Member No.: 187,466 |
I suggest you to use sql server2005 or 2008 version its easy and simple to any environment. you can easily create and run stored procedures there.
Thanks |
|
|
Jun 23 2011, 10:43 PM
Post
#5
|
|
|
Newbie ![]() Group: Members Posts: 3 Joined: 22-June 11 Member No.: 195,243 |
I'd love nothing more, but this is a grad school project and I'm required to use MySQL. It's not a big issue because things work fine on my own localhost. I just wanted to get it going on a remote server. Thanks for your help.
|
|
|
Jun 29 2011, 06:47 AM
Post
#6
|
|
|
Member ![]() ![]() Group: Members Posts: 30 Joined: 24-June 11 Member No.: 195,575 |
I also suggest you to use sql server2005 or 2008 version its easy and simple to any environment. you can easily create and run stored procedures there.
|
|
|
![]() |
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users) |
||
| 0 Members: | ||
Forum Jump |
||
| Lo-Fi Version | Time is now: 20th June 2013 - 07:08 AM |