当前位置:Gxlcms > 数据库问题 > mysql安装

mysql安装

时间:2021-07-01 10:21:17 帮助过:20人阅读

  • 先下载mysql安装包

    • https://downloads.mysql.com/archives/community/

    • 选择第一个比较小的安装包下载即可

  • 解压

  • 在解压后的根目录,新建data目录和my.ini文件

    • data目录:存放数据

    • my.ini:mysql的设置信息

  • 设置my.ini文件内容

    1. <span><span class="cm-bracket">[mysqld<span class="cm-bracket">]<br><span><span class="cm-comment"># 设置3306端口<br><span>port<span class="cm-operator">=<span class="cm-number">3306<br><span><span class="cm-comment"># 设置mysql的安装目录<br><span>basedir<span class="cm-operator">=d<span class="cm-punctuation">:\<span class="cm-variable-2">\mysql\<span class="cm-variable-2">\mysql<span class="cm-operator">-<span class="cm-number">8.0.19<span class="cm-operator">-winx64<br><span><span class="cm-comment">#设置mysql数据库的数据的存放目录<br><span>datadir<span class="cm-operator">=d<span class="cm-punctuation">:\<span class="cm-variable-2">\mysql\<span class="cm-variable-2">\mysql<span class="cm-operator">-<span class="cm-number">8.0.19<span class="cm-operator">-winx64\<span class="cm-variable-2">\data<br><span><span class="cm-comment"># 允许最大连接数<br><span>max_connections<span class="cm-operator">=<span class="cm-number">200<br><span><span class="cm-comment"># 允许连接失败的次数,这是为了防止有人从该主机试图工具数据库系统<br><span>max_connect_errors<span class="cm-operator">=<span class="cm-number">10<br><span><span class="cm-comment"># 服务端使用的字符集默认为UTF-8<br><span><span class="cm-keyword">character<span class="cm-operator">-<span class="cm-keyword">set<span class="cm-operator">-<span class="cm-keyword">server<span class="cm-operator">=utf8<br><span><span class="cm-comment"># 创建新表时将使用的默认存储引擎<br><span><span class="cm-keyword">default<span class="cm-operator">-<span class="cm-keyword">storage<span class="cm-operator">-<span class="cm-keyword">engine<span class="cm-operator">=<span class="cm-keyword">INNODB<br><span><span>?<br><span><span class="cm-bracket">[mysql<span class="cm-bracket">]<br><span><span class="cm-comment"># 设置mysql客户端默认字符集<br><span><span class="cm-keyword">default<span class="cm-operator">-<span class="cm-keyword">character<span class="cm-operator">-<span class="cm-keyword">set<span class="cm-operator">=utf8<br><span><span>?<br><span><span class="cm-bracket">[client<span class="cm-bracket">]<br><span><span class="cm-comment"># 设置mysql客户端连接服务器时默认使用的端口<br><span>port<span class="cm-operator">=<span class="cm-number">3306<br><span><span class="cm-keyword">default<span class="cm-operator">-<span class="cm-keyword">character<span class="cm-operator">-<span class="cm-keyword">set<span class="cm-operator">=utf8</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span>
  • 设置环境变量

    • MYSQL_HOME

      • mysql安装路径

      • D:\mysql\mysql-8.0.19-winx64

    • PATH中添加bin子目录

      • %MYSQL_HOME%\bin

  • 以管理员身份运行cmd,执行初始化命令

    • mysqld --initialize --user=mysql --console

    • 需要记住生成的临时密码:w?z2zjOrclga

  • 注册mysql服务,执行命令

    • mysqld -install

    1. <span><span class="cm-builtin">d:<span class="cm-error">\<span class="cm-identifier">mysql<span class="cm-error">\<span class="cm-identifier">mysql-8<span class="cm-number">.0.19<span class="cm-operator">-<span class="cm-identifier">winx64<span class="cm-operator">><span class="cm-identifier">mysqld <span class="cm-operator">-<span class="cm-identifier">install<br><span><span class="cm-identifier">Service <span class="cm-identifier">successfully <span class="cm-identifier">installed<span class="cm-punctuation">.</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span>
  • 启动mysql服务,执行命令

    • net start mysql

    1. <span><span class="cm-builtin">d:<span class="cm-error">\<span class="cm-identifier">mysql<span class="cm-error">\<span class="cm-identifier">mysql-8<span class="cm-number">.0.19<span class="cm-operator">-<span class="cm-identifier">winx64<span class="cm-operator">><span class="cm-identifier">net <span class="cm-builtin">start <span class="cm-identifier">mysql<br><span><span class="cm-identifier">MySQL <span class="cm-error">服务正在启动 <span class="cm-punctuation">.<br><span><span class="cm-identifier">MySQL <span class="cm-error">服务已经启动成功。</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span>
    • net stop mysql

    1. <span><span class="cm-builtin">PS <span class="cm-builtin">D:<span class="cm-error">\<span class="cm-identifier">wangc<span class="cm-error">\<span class="cm-identifier">Program<span class="cm-error">\<span class="cm-identifier">mysql-8<span class="cm-number">.0.20<span class="cm-operator">-<span class="cm-identifier">winx64<span class="cm-error">\<span class="cm-identifier">bin<span class="cm-operator">> <span class="cm-identifier">net <span class="cm-identifier">stop <span class="cm-identifier">mysql<br><span><span class="cm-identifier">MySQL <span class="cm-error">服务正在停止<span class="cm-punctuation">.<br><span><span class="cm-identifier">MySQL <span class="cm-error">服务已成功停止。</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span>
  • 登录mysql,执行命令

    • mysql -u root -p

    • 输入刚才保存的临时密码

    1. <span><span class="cm-builtin">d:<span class="cm-error">\<span class="cm-identifier">mysql<span class="cm-error">\<span class="cm-identifier">mysql-8<span class="cm-number">.0.19<span class="cm-operator">-<span class="cm-identifier">winx64<span class="cm-operator">><span class="cm-identifier">mysql <span class="cm-operator">-<span class="cm-identifier">u <span class="cm-identifier">root <span class="cm-operator">-<span class="cm-identifier">p<br><span><span class="cm-identifier">Enter <span class="cm-identifier">password<span class="cm-operator">: <span class="cm-operator">************<br><span><span class="cm-identifier">Welcome <span class="cm-identifier">to <span class="cm-identifier">the <span class="cm-identifier">MySQL <span class="cm-identifier">monitor<span class="cm-punctuation">.  <span class="cm-identifier">Commands <span class="cm-keyword">end <span class="cm-identifier">with <span class="cm-punctuation">; <span class="cm-identifier">or <span class="cm-error">\<span class="cm-identifier">g<span class="cm-punctuation">.<br><span><span class="cm-identifier">Your <span class="cm-identifier">MySQL <span class="cm-identifier">connection <span class="cm-identifier">id <span class="cm-identifier">is <span class="cm-number">8<br><span><span class="cm-identifier">Server <span class="cm-identifier">version<span class="cm-operator">: <span class="cm-number">8.0.19<br><span><span>?<br><span><span class="cm-identifier">Copyright <span class="cm-punctuation">(<span class="cm-identifier">c<span class="cm-punctuation">) <span class="cm-number">2000<span class="cm-punctuation">, <span class="cm-number">2020<span class="cm-punctuation">, <span class="cm-identifier">Oracle <span class="cm-identifier">and<span class="cm-operator">/<span class="cm-identifier">or <span class="cm-identifier">its <span class="cm-identifier">affiliates<span class="cm-punctuation">. <span class="cm-identifier">All <span class="cm-identifier">rights <span class="cm-identifier">reserved<span class="cm-punctuation">.<br><span><span>?<br><span><span class="cm-identifier">Oracle <span class="cm-identifier">is <span class="cm-identifier">a <span class="cm-identifier">registered <span class="cm-identifier">trademark <span class="cm-identifier">of <span class="cm-identifier">Oracle <span class="cm-identifier">Corporation <span class="cm-identifier">and<span class="cm-operator">/<span class="cm-identifier">or <span class="cm-identifier">its<br><span><span class="cm-identifier">affiliates<span class="cm-punctuation">. <span class="cm-identifier">Other <span class="cm-identifier">names <span class="cm-identifier">may <span class="cm-identifier">be <span class="cm-identifier">trademarks <span class="cm-identifier">of <span class="cm-identifier">their <span class="cm-identifier">respective<br><span><span class="cm-identifier">owners<span class="cm-punctuation">.<br><span><span>?<br><span><span class="cm-builtin">Type <span class="cm-string">‘help;‘ <span class="cm-identifier">or <span class="cm-string">‘\h‘ <span class="cm-keyword">for <span class="cm-builtin">help<span class="cm-punctuation">. <span class="cm-builtin">Type <span class="cm-string">‘\c‘ <span class="cm-identifier">to <span class="cm-builtin">clear <span class="cm-identifier">the <span class="cm-identifier">current <span class="cm-identifier">input <span class="cm-identifier">statement<span class="cm-punctuation">.<br><span><span>?<br><span><span class="cm-identifier">mysql<span class="cm-operator">></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span>

     

  • 修改root用户的密码为root,执行命令

    • ALTER USER root@localhost IDENTIFIED BY ‘root‘;

    1. <span><span class="cm-identifier">mysql<span class="cm-operator">> <span class="cm-identifier">ALTER <span class="cm-identifier">USER <span class="cm-identifier">root<span class="cm-variable-2">@localhost <span class="cm-identifier">IDENTIFIED <span class="cm-identifier">BY <span class="cm-string">‘root‘<span class="cm-punctuation">;<br><span><span class="cm-identifier">Query <span class="cm-identifier">OK<span class="cm-punctuation">, <span class="cm-number">0 <span class="cm-identifier">rows <span class="cm-identifier">affected <span class="cm-punctuation">(<span class="cm-number">0.01 <span class="cm-identifier">sec<span class="cm-punctuation">)</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span>
  • 退出命令行中mysql模式,然后使用sqlyog登录mysql

    • exit

    1. <span><span class="cm-identifier">mysql<span class="cm-operator">> <span class="cm-keyword">exit<br><span><span class="cm-identifier">Bye</span></span></span></span></span></span>
  • sqlyog下载安装地址

    https://www.cnblogs.com/tangbohu2008/p/11017235.html

mysql安装

标签:community   comment   sqlyog   alt   sql数据库   cli   and   mysql的安装   ror   

人气教程排行