(mysql.info) windows-post-installation
Info Catalog
(mysql.info) post-installation
(mysql.info) post-installation
(mysql.info) unix-post-installation
2.9.1 Windows Post-Installation Procedures
------------------------------------------
On Windows, the data directory and the grant tables do not have to be
created. MySQL Windows distributions include the grant tables with a
set of preinitialized accounts in the `mysql' database under the data
directory. It is unnecessary to run the `mysql_install_db' script that
is used on Unix. Regarding passwords, if you installed MySQL using the
Windows Installation Wizard, you may have already assigned passwords to
the accounts. (See windows-install-wizard.) Otherwise, use the
password-assignment procedure given in default-privileges.
Before setting up passwords, you might want to try running some client
programs to make sure that you can connect to the server and that it is
operating properly. Make sure that the server is running (see
windows-server-first-start), and then issue the following commands to
verify that you can retrieve information from the server. The output
should be similar to what is shown here:
C:\> C:\mysql\bin\mysqlshow
+-----------+
| Databases |
+-----------+
| mysql |
| test |
+-----------+
C:\> C:\mysql\bin\mysqlshow mysql
Database: mysql
+---------------------------+
| Tables |
+---------------------------+
| columns_priv |
| db |
| func |
| help_category |
| help_keyword |
| help_relation |
| help_topic |
| host |
| proc |
| procs_priv |
| tables_priv |
| time_zone |
| time_zone_leap_second |
| time_zone_name |
| time_zone_transition |
| time_zone_transition_type |
| user |
+---------------------------+
C:\> C:\mysql\bin\mysql -e "SELECT Host,Db,User FROM db" mysql
+------+-------+------+
| host | db | user |
+------+-------+------+
| % | test% | |
+------+-------+------+
If you are running a version of Windows that supports services and you
want the MySQL server to run automatically when Windows starts, see
windows-start-service.
Info Catalog
(mysql.info) post-installation
(mysql.info) post-installation
(mysql.info) unix-post-installation
automatically generated byinfo2html