Pretty simple really. Just click next, next and next ...
http://dev.mysql.com/downloads/
Choosing the right file:
· If you have an online connection while running the MySQL Installer, choose the mysql-installer-web-community file.
· If you do NOT have an online connection while running the MySQL Installer, choose the mysql-installer-community file.
Note: MySQL Installer is 32 bit, but will install both 32 bit and 64 bit binaries.
Take note of your password here.
There should be a new software installed in the Start Menu - mySQL Command line client.
password will be the password user typed during the installation.
Just play around with it.
mysql>; select current_user;
+----------------+
| current_user |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.00 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.00 sec)
mysql> use test
Database changed
mysql> show tables;
Empty set (0.00 sec)
mysql> use mysql
Database changed
mysql> show tables;
+--------------------------+
| Tables_in_mysql |
+--------------------------+
| columns_priv |
| db |
| event |
| func |
| general_log |
| help_category |
| help_keyword |
| help_relation |
| help_topic |
| innodb_index_stats |
| innodb_table_stats |
| ndb_binlog_index |
| plugin |
| proc |
| procs_priv |
| proxies_priv |
| servers |
| slave_master_info |
| slave_relay_log_info |
| slave_worker_info |
| slow_log |
| tables_priv |
| time_zone |
| time_zone_leap_second |
| time_zone_name |
| time_zone_transition |
| time_zone_transition_type |
| user |
+---------------------------+
28 rows in set (0.00 sec)
No comments:
Post a Comment