Getting started with mysql database (2)

xiaoxiao2021-03-06  63

(2) Installation 1 under Windows2000. Select the default directory when installing: C: / MySQL 2. Take C: /Mysqlmy-example.cnf Copy as c: my.cnf, and put C: /MysqlibGwinb19.dll Copy to WinntSystem32. 3. The method of starting MySQL is: c: mysql / bin / mysqld-shareware --Install Net Start MySQL is so simple, you can start. 4. Change the password of the superuser (root): c: / mysql / bin / mysql mysql mysql> update user set password = password ('Your password') SwhereSuser = 'root'; mysql> quit c: / mysql / bin / mysqladmin relevoad Use the command c: / mysql / bin / mysqlshow to see the test. Here you should display: --------- | Databases | ----------- | MySQL | | TEST | --------- - See these information This step will prove that there is no problem. C: c: / mysql / bin / mysqlshow --user = root --parsqord = Your password mysql here should be displayed: Database: mysql ----- --------- | Tables | -------------- | Column_Priv | | DB | | Host | | TABLES_PRIV | | User | ----- --------- Everything is done! 5.

转载请注明原文地址:https://www.9cbs.com/read-111959.html

New Post(0)