MySQL Setup in Debian

最新推荐文章于 2025-11-24 15:00:59 发布

转载最新推荐文章于 2025-11-24 15:00:59 发布 · 733 阅读

文章标签：

#mysql #debian #file #user #access #server

linux 同时被 2 个专栏收录

23 篇文章

订阅专栏

TI DaVinci DM368

9 篇文章

订阅专栏

本文介绍如何在LW3xx设备上运行Debian系统时重置MySQL密码的具体步骤，包括从配置文件中获取系统维护用户的密码、通过命令行更新root用户的密码以及调整MySQL配置文件以允许远程访问。

http://codesnippets.joyent.com/posts/show/2038

platform : LW3xx running Debian

First get debian-sys-maint user pass from /etc/mysql/debian.cnf
Example:
debian-sys-maint
YTERYgkjhbsfk87ce

Then:

$mysql -u debian-sys-maint -p
password: (put YTERYgkjhbsfk87ce here)
mysql> UPDATE mysql.user SET Password=PASSWORD('my_new_password') WHERE User='root';
mysql> flush privileges;
mysql> quit

$mysqladmin -u root password my_new_password (I didn't use this one since I don't like remote root access)
$mysqladmin -p -u root -h localhost password my_new_password

-- CONNECTION SETTINGS --
open /etc/mysql/my.cnf file
    sudo vi /etc/mysql/my.cnf

Make sure bind-address set to your server IP address (not to 127.0.0.1)
    bind-address = 192.158.5.1

Also make sure line skip-networking is removed or commented out
    # skip-networking

Save and close the file; Restart mysql
    sudo /etc/init.d/mysql restart