Ubuntu - Edgy Eft下安装配置MySQL

    技术2022-05-11  80

    安装版本信息: Ubuntu 6.10 Edgy Eft MySQL 5.0.24 1:安装MySQL # sudo apt-get install mysql-server 2:登录到MySQL # mysql -u root 3:修改root用户密码 默认情况下root用户的密码为空,因此需要按照以下步骤进行修改: mysql> GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY "yourpasswd"; mysql> flush privileges; 4:增加远程登录 默认情况下,MySQL之允许本地登录,需要修改/etc/mysql/my.cnf文件: 注释这一行: bind-address=127.0.0.1 ==> #bind-address=127.0.0.1 对于需要远程登录的用户执行如下命令: mysql> GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "yourpasswd"; mysql> flush privileges;

    最新回复(0)