Online computer courses, code, programming tutorial and sidebar information for monitoring Canadian S&P/TSX index. Build friendship and networking. Welcome to visit my blogs often!!! I also have two other sites: YouTube Channel and Google site.
Adsense
Popular Posts
- PHPWind-- A PHP forum script applcaition in China
- Free host forum is not reliable
- Formatting my post
- Powerful js library datable to export table in pdf, excel, sorting, freezing column and table header fixed (sticky)
- job interview questions (1)
- Set up a child account and set screen time limit in Windows 8
- PHP: add a download as pdf file button in report page
- phpexcel toggle expand and hide column in EXCEL and summary
- WinMerge - file and folder differencing and merging tool for Windows
- PHP connect IBM db2 database in XAMPP
Monday, February 13, 2012
MySQL Workbench
The MySQL Installer 5.5 package includes MySQL Server 5.5 GA, MySQL Workbench 5.2 G and MySQL Connectors (.Net / ODBC / Java / C / C++) GA. The package can be downloaded for windows in:
http://dev.mysql.com/tech-resources/articles/mysql-installer-for-windows.html
With MySQL Workbench, you do not need to install mysql-gui-tools separately.
When you open MySQL WorkBench, you can clearly see three parts: SQL development, Data Modeling, Server Administration. SQL Development replaces previous MySQL Query Browser. The third part Server Administration in MySQLWorkBench replaces previous MySQL Administrator from MYSQL GUI tools.
To add a new user in database in MySQL WorkBench:
1) Start MySQL Workbench 5.2 CE application, and click server Administration near yellow icon
2) Click "Users and privileges" under Security in left panel, and click add account.
3) Click Schema Privileges at the top menu, click "Add Entry" to select object rights.
In this way, you do not need to run the script to "Add new user".
You also can select "Data Export" and "Data Import/Restore" in Server administration.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment