Stored Procedures through PHPMyAdmin

Still Somewhat New to MySQL Development...

[hsteckylf]

I am developing on a LAMP web server. The server, however is remote from me and I am not able to connect to it through a BASH shell. At this current time, my only means of accessing and manipulating the database is through PHPMyAdmin. After a lot of research, I believe that having several sproc's would dramatically enhance the speed of the pages loading. However, I have searched through PHPMyAdmin and have not been able to find a way to create and store sproc's through it. If anyone can help me out at all it would be greatly appreciated.

[listerine]

1. only Mysql 5 has Stored procedures
2. if you can't login, try to create using like this

grant all to databasename.* to username@'%' identified by 'your-password';

hope this helps

[hsteckylf]

OK, My server is currently running MySQL 3.23.58. What all would be involved with upgrading to 5 and are there any downfalls to doing so?

[coopster]

Welcome to WebmasterWorld, hsteckylf!
And you too, listerine!

MySQL 5.0 [dev.mysql.com] is the current alpha release of the MySQL database server. Since it is still in alpha release, you are using it unsupported and may yet uncover issues. I've been down this road before and if you aren't pushing the bar too far it may be worth the risk if you truly want to start using stored procedures in a LIVE installation. However, as with anything, individual assessment is necessary. Best wishes with the endeavor -- coopster