Home » Forums » DBManager General
 
Editing Stored Procedures in MySQL 5.0.15 (1571 previews)
Editing Stored Procedures in MySQL 5.0.15 Posted in 21th, 09/2006 10:09 by brandc.rd
Hi,

Maybe I'm just stupid but I have a problem with stored procedured in MySQL With the root user there is no problem it can see all the stored procedures in all the databases.

I created a new user throe DB Manager and gave it all the rights to a database. I added a stored procedure throw DB Manager and executed it... and it worked, but afterwards by trying to edit the SP I found that it didn't show under the SP section. I reloged in as root and yes, there were the SP. It seems that with a user (not root) I can add and execute SPs but can edit them, this creats a big problem for me.

Is this a problem with DB Manager or is it a problem in MySQL, or am I just look at it from the wrong direction?

Help or sucgestions will be appreciated.

Cecil
Cecil Brand
Systam Administrator
University of the Free State
Re: Editing Stored Procedures in MySQL 5.0.15 Posted in 21th, 09/2006 11:37 by support
Hi Cecil,

DBManager lists the procedures (as well as functions) from the table mysql.proc. If the user does not have privilege to SELECT in this table then no SP/FUNCTION will be listed at all. In a later version mysql developers implemented the INFORMATION_SCHEMA which is in fact a view to mysql.proc and other objects. This is more useful since any user can SELECT the tables from the information_schema without privilege problems. On the other hand editing a Procedure is tricky if it was created with the user root. DBManager does not check this at all, since it is mysql responsability to deal with that.
I would recommend to not create objects with the user root but with the real user you regularly use to create and manipulate tables.
Also it is good to mention that mysql has some restrictions about Procedures and Functions so a look at mysql's manual would be a good start.

PS: We have decided to postpound the use of INFORMATION_SCHEMA until mysql 5.1.x is ready for production. The reason is that since this was created in mysql 5.0.x it probably will have constant updates causing problems in applications using it to collect information about schemas. Instead we kept the default choice (listing mysql.proc) since it will work in any case anyway. Optionally you can grant the privileges required for all the users you need to SELECT the mysq.proc table.

Hope that helps,



DBTools Support / DBTools Software
RE: Editing Stored Procedures in MySQL 5.0.15 Posted in 13th, 06/2018 04:41 by wq24783670
http://www.hollister.com.de/, http://www.nikefree5.com.co/, http://www.ralphlaurens-polos.co.uk/, http://www.timberland-shoes.net.co/, http://redskins.nfl-jerseys.org/, http://www.long-champ.com.co/, http://www.burberry-storevip.com/, http://www.nikeair-max.es/, http://www.hollister-clothings-store.com/, http://www.nike-store.com.de/, http://www.nike-maxshoes.fr/, http://panthers.nfl-jerseys.org/, http://www.givenchy.com.co/, http://chargers.nfl-jerseys.org/, http://nuggets.nbajerseyssale.com/, http://www.nfl-jerseys.org/, http://www.truereligions.net/, http://www.airhuarache-inc.co.uk/, http://www.toms--outlet.com.co/, http://www.coachoutlet-online.com.co/, http://www.uhren-stores.de/, http://azcardinals.nfl-jerseys.org/, http://pacers.nbajerseyssale.com/, http://www.burberryoutlet-sale.net.co/, http://www.chiflatiron-hair.com/, http://www.linksoflondonvip.com/, http://www.nikerosherun.com.co/, http://www.juicy-coutureoutlet.com/, http://www.airmax-shoes.com/, http://www.michael-korsbags.com.co/, http://www.swarovski-jewelrys.co.uk/, http://www.nikeshoes.mex.com/, http://chiefs.nfl-jerseys.org/, http://www.birkenstockshoes.com.de/, http://www.skechers-shoesoutlet.com/, http://thunder.nbajerseyssale.com/, http://www.chrome-heartsoutlet.com/, http://www.michael-kors.co.nl/, http://www.mizuno.us.com/, http://www.puma-shoes.com.de/, http://www.gucci-shoesoutlet.com/, http://www.timberland-boots.com.co/, http://www.burbagsoutlet.com/, http://www.uggs-boots.com/, http://jets.nfl-jerseys.org/, http://www.thenorth-face.com.co/, http://www.airjordans-shoes.com/, http://www.nike-shoes.org.es/, http://www.rayban-lunettes.fr/, http://www.rolexswatchoutlet.com/, http://www.long-champ.com.de/, http://www.airjordanshoes.com.co/, http://www.mizuno-running.net/, http://www.supra-footwear.net/, http://www.bottega-venetasoutlet.com/, http://www.hollisterclothingcanada.ca/, http://www.oakleysunglasses.org.es/, http://www.nikerosherun.com.de/, http://www.oakleys-outlets.net/, http://www.nbateamonline.com/, http://www.ray-bansoutlet.net.co/, http://www.danskos-shoes.com/, http://www.long-champ-outlet.com/, http://www.coachfactory.cc/, http://www.eyeglassesinsale.com/, http://www.coachblackfriday.com/, http://www.michael-kors-bags.com/, http://www.hollister-outlet.com/, http://www.toms-shoesoutlets.com/, http://www.under-armour.us.com/, http://www.scarpehogan-shoes.it/, http://www.cheap-iphone-cases.com/, http://www.raybans-outletonline.com/, http://www.nbajerseyssale.com/, http://www.true-religionsoutlet.com/, http://www.rosherun-shoes.us/, http://www.pandora-jewelry.com.de/, http://www.michaelkorspurses.co.uk/, http://magic.nbajerseyssale.com/, http://www.tracksuits.com.co/, http://www.cheap-pandora-charms.org.uk/, http://www.ralphlauren-au.com/, http://www.cheap-raybansunglasses.com/, http://www.oakley-outletonline.com.co/, http://www.cheap-watches.com.co/, http://www.montblancs.com.co/, http://bulls.nbajerseyssale.com/, http://www.raybansbocco.it/, http://www.coachoutletonlinemall.com/, http://www.nhljerseys.com.co/, http://www.kate-spades.net/, http://www.converses.us.com/, http://www.replicabags.net.co/, http://www.thomas-sabo.us.com/, http://www.designer-bags.us.com/, http://www.barbours-factory.com/, http://www.asicsshoes-outlet.com/, http://hornets.nbajerseyssale.com/, http://www.raybans-outlet.cc/, http://www.softballbats-sale.com/, http://www.michaelkors.com.de/, http://www.reebok-shoes.co.uk/, http://spurs.nbajerseyssale.com/, http://www.ralphslauren-polo.com.co/, http://www.nfljerseys-sale.com/, http://www.outlet-pradabags.com/, http://www.oakley-sunglassessale.com.co/, http://www.new-balanceoutlet.org/, http://www.ralph-laurenpolos.net/, http://www.converse-schuhe.com.de/, http://www.raybanoutlet.ca/, http://buccaneers.nfl-jerseys.org/, http://www.mcm-backpacks.com.co/, http://www.christian-louboutin.jp.net/, http://www.adidasshoes.com.se/, http://www.burberry-outlets.ca/, http://www.airmax2015.net/, http://cavaliers.nbajerseyssale.com/, http://suns.nbajerseyssale.com/, http://texans.nfl-jerseys.org/, http://www.tommys-hilfigers.net/, http://www.nikeairmax.com.de/, http://raptors.nbajerseyssale.com/, http://www.cheapnhljerseys.us.com/, http://www.raybans.com.de/, http://www.ralphslaurensoutlet.co.uk/, http://trailblazers.nbajerseyssale.com/, http://www.armaniexchange.us.com/, http://www.dsquared2-outlet.com/, http://www.rolex-watches.us.com/, http://rams.nfl-jerseys.org/, http://steelers.nfl-jerseys.org/, http://www.rl-ralphlauren-polos.co.uk/, http://lions.nfl-jerseys.org/, http://www.air-yeezyshoes.com/, http://www.skechers-canada.ca/, http://patriots.nfl-jerseys.org/, http://www.swarovski-canada.ca/, http://www.converse-shoes-outlet.com/, http://www.ralphlaurens-outlet.net/, http://www.nike-factory.com.co/, http://www.jimmychoo-shoes.com/, http://www.christian-louboutin-shoes.com/, http://www.salvatoreferragamo.us.com/, http://www.barbours.us.com/, http://www.barbour-jackets.in.net/, http://grizzlies.nbajerseyssale.com/, http://www.nikeshoesoutlet.co.nl/, http://www.woolrich-jackets.com/, http://www.parajumpersjacketsoutlet.com/, http://www.pandora-charmscanada.ca/, http://www.hogans.com.de/, http://www.rolex-watchescanada.ca/, http://www.versaceoutlet.us.com/, http://49ers.nfl-jerseys.org/, http://michaelkors.euro-us.net/, http://www.pandora-jewelrys.com/, http://www.montrespascher.fr/, http://www.coachoutlet.fr/, http://www.jerseys-store.com/, http://www.cheap-jerseys.mex.com/, http://www.hollister-store.com.co/, http://www.michaelkors.so/, http://pelicans.nbajerseyssale.com/, http://www.calvin-kleinoutlet.com/, http://www.chiflatironhair.us.com/, http://www.jimmychoos-shoes.com/, http://www.pandora-jewelry.top/, http://www.michaelkorsbagsvip.com/, http://www.nike-shoesoutlet.us.org/, http://www.adidassuper-star.com.de/, http://www.fendi-outlet.us.com/, http://www.burbsoutlet.co.uk/, http://www.sunglasses-outletonline.com/, http://coachoutlet.euro-us.net/, http://www.christianlouboutinoutlet.net.co/, http://www.nike-mercurial.com/, http://www.tommyhilfiger-outlet.net/, http://www.stone-islandestore.com/, http://www.asicsoutlet.net/, http://bengals.nfl-jerseys.org/, http://www.christian-louboutins.com/, http://www.eccoshoesoutlet.com/, http://www.raybans-cher.fr/, http://www.adidas-shoes.es/, http://www.belstaffjacketsoutlet.co.uk/, http://www.michaelkorsviponline.com/, http://www.fredperrypolos.co.uk/, http://www.toms-shoesstore.com.co/, http://www.northfacejackets.fr/, http://www.nike-shoesoutlet.com/, http://titans.nfl-jerseys.org/, http://www.hermesbags-outlet.com/, http://www.soccers-shoes.us.com/, http://www.louboutinshoes.jp.net/, http://www.new-iphonecases.com/, http://www.coach-outlets.net.co/, http://www.ralphlauren-canada.ca/, http://www.converse-shoes.net/, http://www.ralph-laurenoutlets.com/, http://www.longchamps-bags.us.com/, http://www.kate-spadebags.com/, http://www.northface-jackets.co.uk/, http://www.burberryoutletonline.com.de/, http://www.oakleysframesvip.com/, http://giants.nfl-jerseys.org/, http://www.philipppleinblog.com/, http://www.jerseys.net.in/, http://www.outlet-true-religion.com/, http://www.mcmshandbags.com.co/, http://heat.nbajerseyssale.com/, http://www.outlet-michaelskors.com/, http://kings.nbajerseyssale.com/, http://nets.nbajerseyssale.com/, http://www.nikefreerunshoes.com/, http://www.mbt-shoesoutlet.com/, http://www.belstaff-jackets.us.com/, http://www.rayban-wear.co.uk/, http://www.basketballshoes.com.co/, http://www.barbour-jackets.us.com/, http://www.lacoste-polos.us.com/, http://www.oakleysunglasses-canada.ca/, http://www.ray-bans.net.co/, http://www.co-aol.com/, http://www.the-northface.ca/, http://www.skechers-outlet.com/, http://www.australia-uggs.com/, http://www.giuseppes-zanottishoes.com/, http://colts.nfl-jerseys.org/, http://www.cheapjerseys-outlet.com/, http://www.coach-factoryoutlet.net.co/, http://www.ferragamo.net.co/, http://www.vans-shoesoutlet.co.uk/, http://jazz.nbajerseyssale.com/, http://www.katespades.com.co/, http://wizards.nbajerseyssale.com/, http://www.cheap-michaelkors.com.co/, http://seahawks.nfl-jerseys.org/, http://www.new-balanceshoes.es/, http://www.swarovskionlineshop.com.de/, http://vikings.nfl-jerseys.org/, http://www.salvatore-ferragamos.com/, http://eagles.nfl-jerseys.org/, http://coach.euro-us.net/, http://www.vibram--fivefingers.com/, http://www.polo-ralphlaurens.com.co/, http://www.newbalanceschuhe.com.de/, http://www.coach-outletonline.ca/, http://www.nikeroshe-run.com.es/, http://www.supra-footwears.com/, http://lakers.nbajerseyssale.com/, http://www.michaelkorsoutletvip.com/, http://www.airhuarache-shoes.co.uk/, http://www.cheap-mlbjerseys.us.com/, http://www.nike-paschers.fr/, http://www.polo-ralphlaurens.us.com/, http://www.tommyhilfigers.com.de/, http://www.retrojordan-shoes.com/, http://www.christian-louboutinshoesoutlet.com/, http://www.dsquared2s.com/, http://www.raybans-outlet.co.nl/, http://www.nikefrees-shoes.co.uk/, http://www.prada-shoes.us.org/, http://www.ralphlaurens.com.de/, http://www.valentinoshoes-outlet.com/, http://www.salomonshoes.com.de/, http://76ers.nbajerseyssale.com/, http://www.horlogesrolexs.co.nl/, http://www.asics-shoesoutlet.net/, http://www.australia-michaelkors.com/, http://www.outletburberry-bags.com/, http://www.michaelkorsoutlet.online/, http://bucks.nbajerseyssale.com/, http://www.nikeshoes-canada.ca/, http://www.jordan.com.de/, http://www.hugo-boss.com.co/, http://www.toms-outletonline.com.co/, http://www.nikefreerun-inc.co.uk/, http://www.timberland-boots.fr/, http://www.versaces-outlet.com/, http://www.coachoutletonline.vip/, http://www.newbalance-canada.ca/, http://www.polos-ralphlaurens.co.uk/, http://bears.nfl-jerseys.org/, http://www.mk-com.com/, http://www.thomas-sabos.com.de/, http://www.pradas.com.de/, http://www.ralphslauren-polo.com/, http://www.prada-outlet.net.co/, http://www.nikeairforce.com.de/, http://www.birkenstocks.com.de/, http://www.oakleys-sunglasses.com.co/, http://www.babylisspros.com/, http://www.belstaff-outlet.com/, http://www.hermesbagsoutlet.com/, http://www.nike-airmax.com.de/, http://www.bcbg-canada.ca/, http://www.outlet-tommyhilfigers.com/, http://www.cheapshoes.net.co/, http://www.michael-korsoutletonline.com.co/, http://www.outletonline-michael-kors.co.uk/, http://www.handbags-outlet.in.net/, http://www.tommyhilfigers.co.nl/, http://www.sac-hermes.fr/, http://www.barboursjackets.com/, http://www.nike-rosherun.co.nl/, http://www.toryburchs.us.com/, http://www.long-champhandbags.com/, http://www.gbyguess.us.com/, http://www.ralphlauren.mex.com/, http://warriors.nbajerseyssale.com/, http://www.michael-kors.com.es/, http://www.nikeairmax-australia.com/, http://www.rosherun-shoes.co.uk/, http://www.raybansoutlet.co.uk/, http://clippers.nbajerseyssale.com/, http://www.outlet-michaelkors-online.com/, http://www.oakley-outlet.fr/, http://www.outlet-pradas.com/, http://www.mcmbackpacks.com/, http://falcons.nfl-jerseys.org/, http://www.ray-bans.com.co/, http://www.michael-kors.net.co/, http://www.guccishoes.net.in/, http://www.cheap-juicycouture.com/, http://www.under-armouroutlet.com/, http://www.nike-huarache.co.nl/, http://www.coach-factorys.com/, http://www.levis-jeansoutlet.com/, http://www.cheap-raybansoutlet.com.co/, http://www.polos-ralphlauren.com.co/, http://www.coachoutlet-coachoutletonline.com/, http://www.oakleyssunglassesvip.com/, http://www.michaelkors-bags.co.uk/, http://www.cheap-omegas-watches.com/, http://www.the-north-face-jackets.com/, http://www.celinefactory.com/, http://www.mlbjerseys.com.co/, http://www.hollister-clothings.us.com/, http://www.outlet-true-religion.us.org/, http://www.cheap-timberlandboots.com/, http://www.coach-factory.com.co/, http://www.rayban-sunglasses.co/, http://www.jack-wolfskin.us.com/, http://www.hermes-birkinoutlet.com/, http://www.marcjacobs-outlet.com/, http://www.poloralphlaurens.com.de/, http://www.vansschuhe.com.de/, http://www.swarovskijewellery-au.com/, http://www.philipppleins.us.com/, http://www.nikeair-max.ca/, http://www.the-northface.in.net/, http://www.pandorajewellery.com.es/, http://www.coachoutlet-usa.com/, http://jaguars.nfl-jerseys.org/, http://www.ferragamo-inc.co.uk/, http://www.burbsbags.co.uk/, http://timberwolves.nbajerseyssale.com/, http://celtics.nbajerseyssale.com/, http://www.vansshoes-outlet.com/, http://www.true-religions.com/, http://www.replica-bagsoutlet.com/, http://www.airmax-90.com/, http://www.oakleys.com.de/, http://www.burberoutlet.com/, http://www.airmax.com.se/, http://www.nikeshoes.com.de/, http://www.adidas-shoes.ca/, http://www.outlet-ralphlauren.co.uk/, http://ravens.nfl-jerseys.org/, http://www.nike-airmax.in.net/, http://www.fred-perrys.co.uk/, http://www.polos-outletsstore.com/, http://www.oakestore.com/, http://www.mcm-bagsoutlet.com/, http://hawks.nbajerseyssale.com/, http://www.outlet-pumashoes.com/, http://www.ralphlaurens.com.co/, http://www.oakley-sbocco.it/, http://www.moncler-jackets.com.co/, http://www.nba-jerseys.com.co/, http://www.hoodiesoutlet.net/, http://www.the-northface.com.de/, http://www.the-north-face.com.co/, http://www.toms-shoe.us.org/, http://www.fitflop-outlet.com/, http://rockets.nbajerseyssale.com/, http://www.giuseppezanotti.com.co/, http://www.nike-skos.com/, http://www.nike-free-runs.de/, http://www.cheapmontblanc-pens.com/, http://www.canada-michaelkors.ca/, http://www.the-north-face.net.co/, http://www.michaelkorsbags-outlet.com/, http://www.oakleysoutlet.com.co/, http://www.ed-hardy.us.com/, http://www.soccershoes-outlet.com/, http://www.burberbags.com/, http://www.longchamp-outlet.com.co/, http://www.adidasschuhe-online.com.de/, http://www.raybansasses.com/, http://www.cheap-baseballbats.us/, http://www.oakleyframeslrc.com/, http://www.ferragamos.us.com/, http://broncos.nfl-jerseys.org/, http://www.oakleys-online.com.co/, http://www.marc-jacobs.com.co/, http://www.omegas-relojes.es/, http://www.hogan-shoesoutlet.co.uk/, http://www.nike-shoes-outlet.co.uk/, http://www.watch-rolex.co.uk/, http://raiders.nfl-jerseys.org/, http://mavericks.nbajerseyssale.com/, http://www.new-balanceshoes.com/, http://dolphins.nfl-jerseys.org/, http://www.air-maxschoenen.co.nl/, http://pistons.nbajerseyssale.com/, http://www.tommy-hilfigers.de/, http://saints.nfl-jerseys.org/, http://www.pandora-jewellery.com.es/, http://www.lacosteoutlet.com.co/, http://www.soccershoes.us.com/, http://www.zccoachoutlet.com/, http://www.oakleyslrc.com/, http://www.burberryhandbagsvip.com/, http://browns.nfl-jerseys.org/, http://www.ok-em.com/, http://www.adidas-shoes.com.co/, http://www.ray-bans.org.es/, http://www.rolexwatchesforsale.us.com/, http://www.oakleyssunglasslrc.com/, http://www.jackwolfskinoutlet.ca/, http://www.fidgetspinner.com.co/, http://www.outlet-toryburchshoes.com/, http://www.nba-shoes.com/, http://www.bcbg-dresses.net/, http://www.nike-shoes.com.co/, http://www.christian-louboutins.us.com/, http://www.adidas-shoesoutlet.com/, http://www.nike-shoes.com.se/, http://packers.nfl-jerseys.org/, http://www.adidas-shoes.co.nl/, http://www.birkenstock-shoes.com/, http://www.mcm-handbags.com.co/, http://www.ralph-laurens-polos.com/, http://bills.nfl-jerseys.org/, http://www.crystals-swarovskis.com/, http://www.cheap-jordans.com.co/, http://www.hollister.com.se/, http://www.tods-shoesoutlet.com/, http://www.thomassabos-jewelrys.org.uk/, http://www.monclers-outlet.us.com/, http://www.omegas-watches.com.co/, http://www.nikeairmax-isc.co.uk/, http://www.guessfactorys.com/, http://www.guci-heaven.com/, http://www.nikeairmax-shoes.fr/, http://www.christianlouboutin-shoes.ca/, http://www.jordan-retros.com/, http://www.kate-spade-outlet.us.com/, http://www.cc-beanies.us.com/, http://www.reeboks.com.de/, http://www.the-northfacejackets.net.co/, http://www.bottega-outlet.com/, http://www.tommyhilfigerca.ca/, http://www.burberrys-outletonline.in.net/, http://www.tomsshoes-outlet.us.org/, http://www.lonchamp.us.com/, http://www.jewelrys-swarovski.com/, http://www.michaelkorsoutlet.se/, http://www.burberry-store.com/, http://www.jeans-truereligion.com/, http://cowboys.nfl-jerseys.org/, http://knicks.nbajerseyssale.com/

wq123 / usa

Editing Stored Procedures in MySQL 5.0.15 (1571 previews)
Legends

Topic has Replies
Topic With no Replies
 
Home » Forums » DBManager General