首页 > 代码库 > debian安装mysql

debian安装mysql

2024-07-20 04:03:30   223人阅读

http://thirteen-tw.blogspot.com/2008/09/debian-mysql-server.html
    • 安裝MySQL-Server

      debian:~# apt-get install mysql-server

    • 啟動MySQL-Server

      debian:~# /etc/init.d/mysql start

    • Client端連線到MySQL-Server

      本機

      debian:~# mysql -u root -p

      遠端

      debian:~# mysql -h 140.134.210.131 -u root- p

    • 資料庫操作

      1. 在本機以client程式連線

        debian:~# mysql -u root -p

      2. 進入後以指令查詢
        mysql>show databases;
        mysql>create database fcu;
        mysql>show databases;

      3. 建立管理者(roor)遠端連線帳號
        mysql>GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED By "something" WITH GRANT OPTION;

        IDENTIFIED By "something" something為密碼

      4. 增加w01使用者可以使用資料庫wdb權限

        mysql>grant all privileges on wdb.* to w01@localhost IDENTIFIED By "1234"

      5. 刷新資料庫

        mysql> FLUSH PRIVILEGES;

    • 設定my.cnf

      debian:~# vi /etc/mysql/my.cnf

      fix

      #bind-address = 127.0.0.1

    • 設定mysql密碼

      msyql- u root -P
      mysql>set password for root@"%"=password(‘rootpwd‘);

    • mysql語法教學網站

debian安装mysql


联系
我们