homepage Welcome to WebmasterWorld Guest from 54.227.12.4
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
Forum Library, Charter, Moderators: coopster & jatar k

PHP Server Side Scripting Forum

    
Stored Procedures through PHPMyAdmin
Still Somewhat New to MySQL Development...
hsteckylf




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

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




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

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




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

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




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

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

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved