MySQL
- Started
- Last post
- 14 Responses
- 187LockDown
Can anyone point me in the direction of a good MySQL tutorial or document that can explain to me how to lock down MySQL and create a new root user & pass. Im having trouble and the only way I can use MySQL is with the default root without pass. Everytime I try and set up a new root I lock myself out.
BTW Im an idiot!
- 187LockDown0
Just looking for some helpful MySQL links that don't read like Greek. Im a novice but Im learning fast. Basically I know all the commands etc. to build edit update etc.. But Users & Paswwords I get all F'd up.
- unfittoprint0
This is better tha any tutorial. After reading this (it's very beginner-friendly) you'll be able to really accomplish some advanced backend/database projects. It's definetely worth the time.
- 187LockDown0
thanks I will check it out, but Im quite broake at the momant and was looking for something online. Oh well. I will resort to the manual if I have to. I just know there is a bunch of stuff in there I dont need to know, ANd im learning PHP at the same time so time wated is wel uhh.
- unfittoprint0
If you have Kazaa, you can search some PDF documents about MySQL and Web Development. Pretty good stuff.
- 187LockDown0
thats a good idea didnt even think of that.
- ********0
187 on the MOFO block.
- chl0
Get and install phpMyAdmin. It's really pretty easy to do with that.
- 187LockDown0
Cool. this should do the trick.
I already got MySQLCC
alot like Enterprise Manager
Like it alot.I have recently discovered the world of PHP & MySQL on Windows. Makes it alot easier to learn this stuff. than my linux machine. I get lost in there.
- urbankid0
there are some nice articles about MySql and PHP at this web http://www.devarticles.com/
happy reading!
- unfittoprint0
I prefer using something like eSKUel (more user friendly) than phpMyAdmin.
http://www.phptools4u.com/script…
Oh, if you're using the latest php version, 4.3 there's a lot of new security issues like for example: global variables are by default turned off.
- 8dot30
go to C:WINDOWSmy.ini and your settings are there.
- 187LockDown0
Thanks Urban Kid. Will take a look at that site. So my Global variables oare turned off and I need to turn it on in my ini file.?
- unfittoprint0
Don't turn them on, because it's a security precution. Use the new global php variables. one way to go around it and use these received variables is to do something like:
foreach ($HTTP_GET_VARS as $key => $value){
$$key = $value
}or
foreach ($HTTP_POST_VARS as $key => $value){
$$key = $value
}have fun.
- 187LockDown0
Is there a Free GUI App for MySQL for building Querys.
I don't feel like typing. PHPMyAdmin does this right, in the Querys section of your DB.
Does MySQL Control Center do this? I can't seem to find it in there, only a text editor with colorcoding for handcoding them.
??