Welcome to WebmasterWorld Guest from 50.19.34.234

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

Stored Procedures through PHPMyAdmin

Still Somewhat New to MySQL Development...

     

hsteckylf

5:09 pm on Aug 16, 2004 (gmt 0)

10+ Year Member



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

5:32 pm on Aug 16, 2004 (gmt 0)

10+ Year Member



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

5:38 pm on Aug 16, 2004 (gmt 0)

10+ Year Member



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

6:06 pm on Aug 16, 2004 (gmt 0)

WebmasterWorld Administrator coopster is a WebmasterWorld Top Contributor of All Time 10+ Year Member



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

 

Featured Threads

Hot Threads This Week

Hot Threads This Month