Jare's Homepage



Navigation

News
Gallery
Downloads
Articles
Links
Books
About Me

RSS



Archives

Blogs

GameDevBlog
Joel On Software
The Old New Thing
The Daily WTF
Sarcastic Gamer
The Escapist
Indie Games
Raph Koster
Amit's Blobs
Lost Garden
Penny Arcade!
The Ludologist
Grumpy Gamer
AI Game Dev
Click Nothing


Misc

Digital Gunfire Radio






You are visitor #

according to
Web-Counter
(C) Copyright
2000-2005
by
Javier Arévalo Baeza


Site News

MySQL  (Jare)April 17th, 2011 - 13:33
In the previous post, I made references to MySQL but didn't say anything about a quick local setup. So here's what I did for mine:

- Download MySQL binaries from http://dev.mysql.com/downloads/mysql/. I chose the huge 64-bit Zip archive.
- I unzipped the /bin/, /data/, /docs/ and /share/english/ folders into my destination MySQL folder. Then I deleted all the *.pdb files.
- Start the server via start mysqld. You can later stop it with mysqladmin.exe shutdown -u root.
- By default it has a root user without password, and an anonymous user.
- Run the client with mysql -u root.
- Delete the anonymous user or it will mess up with your ability to connect using other users you create: DELETE FROM mysql.user WHERE user=''; FLUSH PRIVILEGES;
- Create your database and your development user: CREATE DATABASE MyDatabase; GRANT SELECT, CREATE, DELETE, UPDATE, INSERT ON MyDatabase.* to MyUser@'%' IDENTIFIED BY "MyPassword";
- Now you can connect as your development user with mysql -u MyUser -pMyPassword.
- I recommend downloading MySQL Workbench from http://dev.mysql.com/downloads/workbench/ to perform database maintenance.