欧美bbbwbbbw肥妇,免费乱码人妻系列日韩,一级黄片

綠色版 mysql 安裝配置

 更新時(shí)間:2009年06月18日 22:28:42   作者:  
好多朋友對(duì)于mysql的配置不是很清楚,其實(shí)最新本的配置也是這樣的,建議大家到s.jb51.net去下載一些服務(wù)器軟件。
一、下載MySQL
http://www.mysql.org/downloads
我下載的是mysql-noinstall-5.0.67-win32.zip
二、安裝過程
 1、解壓縮
mysql-noinstall-5.0.67-win32.zip 到一個(gè)C盤,重新命名為 MySQL5 。
      假定MYSQL_HOME=C:\
MySQL5
 2、編輯mysql的運(yùn)行配置文件my.ini,如果沒有,可以拿my-medium.ini復(fù)制然后更名成 my.ini 
復(fù)制代碼 代碼如下:

# Example MySQL config file for medium systems.  
#  
# This is for a system with little memory (32M - 64M) where MySQL plays  
# an important part, or systems up to 128M where MySQL is used together with  
# other programs (such as a web server)  
#  
# You can copy this file to  
# /etc/my.cnf to set global options,  
# mysql-data-dir/my.cnf to set server-specific options (in this  
# installation this directory is C:\mysql\data) or  
# ~/.my.cnf to set user-specific options.  
#  
# In this file, you can use all long options that a program supports.  
# If you want to know which options a program supports, run the program  
# with the "--help" option.  

# The following options will be passed to all MySQL clients  
[client]  
#password   = your_password 
port        = 3306 
socket      = /tmp/mysql.sock  

# Here follows entries for some specific programs  

# The MySQL server  
[mysqld]  
basedir = "C:\MySQL5" 
datadir = "C:\MySQL5\data" 
default-character-set=utf8 

port        = 3306 
socket      = /tmp/mysql.sock  
skip-locking  
key_buffer = 16M 
max_allowed_packet = 1M 
table_cache = 64 
sort_buffer_size = 512K 
net_buffer_length = 8K 
read_buffer_size = 256K 
read_rnd_buffer_size = 512K 
myisam_sort_buffer_size = 8M 

# Don't listen on a TCP/IP port at all. This can be a security enhancement,  
# if all processes that need to connect to mysqld run on the same host.  
# All interaction with mysqld must be made via Unix sockets or named pipes.  
# Note that using this option without enabling named pipes on Windows  
# (via the "enable-named-pipe" option) will render mysqld useless!  
#   
#skip-networking  

# Disable Federated by default  
skip-federated  

# Replication Master Server (default)  
# binary logging is required for replication  
log-bin=mysql-bin  

# required unique id between 1 and 2^32 - 1  
# defaults to 1 if master-host is not set  
# but will not function as a master if omitted  
server-id   = 1 

# Replication Slave (comment out master section to use this)  
#  
# To configure this host as a replication slave, you can choose between  
# two methods :  
#  
# 1) Use the CHANGE MASTER TO command (fully described in our manual) -  
#    the syntax is:  
#  
#    CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,  
#    MASTER_USER=<user>, MASTER_PASSWORD=<password> ;  
#  
#    where you replace <host>, <user>, <password> by quoted strings and  
#    <port> by the master's port number (3306 by default).  
#  
#    Example:  
#  
#    CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,  
#    MASTER_USER='joe', MASTER_PASSWORD='secret';  
#  
# OR  
#  
# 2) Set the variables below. However, in case you choose this method, then  
#    start replication for the first time (even unsuccessfully, for example  
#    if you mistyped the password in master-password and the slave fails to  
#    connect), the slave will create a master.info file, and any later  
#    change in this file to the variables' values below will be ignored and  
#    overridden by the content of the master.info file, unless you shutdown  
#    the slave server, delete master.info and restart the slaver server.  
#    For that reason, you may want to leave the lines below untouched  
#    (commented) and instead use CHANGE MASTER TO (see above)  
#  
# required unique id between 2 and 2^32 - 1  
# (and different from the master)  
# defaults to 2 if master-host is set  
# but will not function as a slave if omitted  
#server-id       = 2 
#  
# The replication master for this slave - required  
#master-host     =   <hostname> 
#  
# The username the slave will use for authentication when connecting  
# to the master - required  
#master-user     =   <username> 
#  
# The password the slave will authenticate with when connecting to  
# the master - required  
#master-password =   <password> 
#  
# The port the master is listening on.  
# optional - defaults to 3306  
#master-port     =  <port> 
#  
# binary logging - not required for slaves, but recommended  
#log-bin=mysql-bin  

# Point the following paths to different dedicated disks  
#tmpdir     = /tmp/       
#log-update     = /path-to-dedicated-directory/hostname  

# Uncomment the following if you are using BDB tables  
#bdb_cache_size = 4M 
#bdb_max_lock = 10000 

# Uncomment the following if you are using InnoDB tables  
#innodb_data_home_dir = C:\mysql\data/  
#innodb_data_file_path = ibdata1:10M:autoextend  
#innodb_log_group_home_dir = C:\mysql\data/  
#innodb_log_arch_dir = C:\mysql\data/  
# You can set .._buffer_pool_size up to 50 - 80 %  
# of RAM but beware of setting memory usage too high  
#innodb_buffer_pool_size = 16M 
#innodb_additional_mem_pool_size = 2M 
# Set .._log_file_size to 25 % of buffer pool size  
#innodb_log_file_size = 5M 
#innodb_log_buffer_size = 8M 
#innodb_flush_log_at_trx_commit = 1 
#innodb_lock_wait_timeout = 50 

[mysqldump]  
quick  
max_allowed_packet = 16M 

[mysql]  
no-auto-rehash  
# Remove the next comment character if you are not familiar with SQL  
#safe-updates  

[isamchk]  
key_buffer = 20M 
sort_buffer_size = 20M 
read_buffer = 2M 
write_buffer = 2M 

[myisamchk]  
key_buffer = 20M 
sort_buffer_size = 20M 
read_buffer = 2M 
write_buffer = 2M 

[mysqlhotcopy]  
interactive-timeout

[mysqld]
# 設(shè)置mysql的安裝目錄
basedir=$MYSQL_HOME
# 設(shè)置mysql數(shù)據(jù)庫的數(shù)據(jù)的存放目錄,必須是data,或者是\\xxx\data
datadir=$MYSQL_HOME\data
# 設(shè)置mysql服務(wù)器的字符集
default-character-set=utf8

[client]
# 設(shè)置mysql客戶端的字符集
default-character-set=gbk

3、安裝mysql服務(wù)
從MS-DOS窗口進(jìn)入目錄E:\myserver\mysql-5.0.37-win32\bin,運(yùn)行如下命令:
mysqld --install mysql --defaults-file=C:\MySQL5\my.ini

4、啟動(dòng)mysql數(shù)據(jù)庫
還在上面的命令窗口里面,輸入命令:net start mysql
這樣就啟動(dòng)了mysql 服務(wù)。

5、停止服務(wù)
執(zhí)行 net stop mysql 即可
6、刪除服務(wù)
執(zhí)行mysqld --remove mysql 即可

7、修改密碼
以上安裝完畢之后,默認(rèn)的root用戶密碼為空的。為了安全起見,需要設(shè)置一個(gè)root用戶的密碼。
復(fù)制代碼 代碼如下:

<STRONG><SPAN style="COLOR: #ffffff" style="COLOR: #ffffff">C:\>cd MySQL5  

C:\MySQL5>cd bin  

C:\MySQL5\bin>mysql -uroot -p  
Enter password:  
Welcome to the MySQL monitor.  Commands end with ; or \g.  
Your MySQL connection id is 3  
Server version: 5.0.67-community-log MySQL Community Edition (GPL)  

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.  

mysql> use mysql  
Database changed  
mysql> update User set Password=PASSWORD('admin') where User='root';  
Query OK, 2 rows affected (0.08 sec)  
Rows matched: 2  Changed: 2  Warnings: 0</SPAN> 

</STRONG>

相關(guān)文章

  • MySQL嵌套查詢實(shí)現(xiàn)子查詢的方法

    MySQL嵌套查詢實(shí)現(xiàn)子查詢的方法

    本文主要介紹了MySQL嵌套查詢實(shí)現(xiàn)子查詢的方法,文中通過示例代碼介紹的非常詳細(xì),具有一定的參考價(jià)值,感興趣的小伙伴們可以參考一下
    2022-02-02
  • mysql 8.0.16 winx64安裝配置方法圖文教程

    mysql 8.0.16 winx64安裝配置方法圖文教程

    這篇文章主要為大家分享了mysql 8.0.16 安裝配置方法圖文教程,具有一定的參考價(jià)值,感興趣的朋友可以參考一下
    2019-05-05
  • mysql 創(chuàng)建root用戶和普通用戶及修改刪除功能

    mysql 創(chuàng)建root用戶和普通用戶及修改刪除功能

    這篇文章主要介紹了mysql 創(chuàng)建root用戶和普通用戶及修改刪除功能,需要的朋友可以參考下
    2017-05-05
  • 如何查看MySQL連接的root密碼

    如何查看MySQL連接的root密碼

    前幾天在用Navicat去連本地的MySQL的時(shí)候發(fā)現(xiàn)我已經(jīng)忘了密碼了,試了網(wǎng)上很多方式都不行…后來發(fā)現(xiàn)其實(shí)可以自己直接去看當(dāng)初設(shè)置的密碼,下面將方法總結(jié)出來分享給大家,有需要的朋友們可以參考借鑒,下面來一起看看吧。
    2017-01-01
  • MySQL語句匯總整理

    MySQL語句匯總整理

    這篇文章主要給大家分享的是MySQL語句匯總整理,圍繞MySQL語句的相關(guān)資料對(duì)其進(jìn)行整理,具有一定的參考價(jià)值,需要的小伙伴可以參考一下,希望對(duì)你有所幫助
    2021-12-12
  • mysql索引失效的十大問題小結(jié)

    mysql索引失效的十大問題小結(jié)

    最近生產(chǎn)爆出一條慢sql,原因是用了or和!=,導(dǎo)致索引失效。于是,總結(jié)了索引失效的十大雜癥,具有一定的參考價(jià)值,感興趣的小伙伴們可以參考一下
    2021-09-09
  • Mysql數(shù)據(jù)庫的QPS和TPS的意義和計(jì)算方法

    Mysql數(shù)據(jù)庫的QPS和TPS的意義和計(jì)算方法

    今天小編就為大家分享一篇關(guān)于Mysql數(shù)據(jù)庫的QPS和TPS的意義和計(jì)算方法,小編覺得內(nèi)容挺不錯(cuò)的,現(xiàn)在分享給大家,具有很好的參考價(jià)值,需要的朋友一起跟隨小編來看看吧
    2019-03-03
  • 值得收藏的mysql常用命令集錦

    值得收藏的mysql常用命令集錦

    這篇文章主要為大家整理了mysql常用命令匯總,連接Mysql、修改mysql密碼、數(shù)據(jù)庫的創(chuàng)建刪除等,具有一定的參考價(jià)值,感興趣的小伙伴們可以參考一下
    2016-11-11
  • MySQL常用表級(jí)操作總結(jié)

    MySQL常用表級(jí)操作總結(jié)

    這篇文章主要為大家詳細(xì)介紹了MySQL中常用的表級(jí)操作,文中的示例代碼簡潔易懂,對(duì)我們學(xué)習(xí)MySQL有一定的幫助,感興趣的小伙伴可以學(xué)習(xí)一下
    2023-08-08
  • SQLServer 2005 自動(dòng)備份數(shù)據(jù)庫的方法分享(附圖解教程)

    SQLServer 2005 自動(dòng)備份數(shù)據(jù)庫的方法分享(附圖解教程)

    SQLServer 2005 自動(dòng)備份數(shù)據(jù)庫的方法分享(附圖解教程),使用sqlserver2005的朋友可以參考下。
    2011-09-09

最新評(píng)論