linux下使用mysql的小问题
刚刚迁移一个项目到新安装的linux系统下,因为要用mysql所以安装了个: yum install mysql yum install mysql-server 然后启动mysql服务: service mysqd start 这时候已经可以登陆了,只是root用户应该没有密码的,未免不安全,故设置密码: mysqladmin pas
刚刚迁移一个项目到新安装的linux系统下,因为要用mysql所以安装了个:
yum install mysql
yum install mysql-server
然后启动mysql服务:
service mysqd start
这时候已经可以登陆了,只是root用户应该没有密码的,未免不安全,,故设置密码:
mysqladmin password ‘123’
然后,然后就无法登陆了。。。无论输入密码123还是不输入密码都登陆不了。。。求各位大神解答。
我只能先停止服务,再重置密码了,第二步是用特殊的模式进入mysql,非长久之计:
service mysqld stop
mysqld_safe --skip-grant-tables &
好了,可以进入了:
mysql -uroot -p
选择数据库:
use mysql;
设置密码:
update user set password=PASSWORD("newpass")where user="root";
更新权限:
flush privileges;
退出:
quit
重启mysql服务:
service mysqld restart
新密码进入:
mysql -uroot -p

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics





The main role of MySQL in web applications is to store and manage data. 1.MySQL efficiently processes user information, product catalogs, transaction records and other data. 2. Through SQL query, developers can extract information from the database to generate dynamic content. 3.MySQL works based on the client-server model to ensure acceptable query speed.

I encountered a tricky problem when developing a small application: the need to quickly integrate a lightweight database operation library. After trying multiple libraries, I found that they either have too much functionality or are not very compatible. Eventually, I found minii/db, a simplified version based on Yii2 that solved my problem perfectly.

Although Notepad cannot run Java code directly, it can be achieved by using other tools: using the command line compiler (javac) to generate a bytecode file (filename.class). Use the Java interpreter (java) to interpret bytecode, execute the code, and output the result.

The main uses of Linux include: 1. Server operating system, 2. Embedded system, 3. Desktop operating system, 4. Development and testing environment. Linux excels in these areas, providing stability, security and efficient development tools.

Laravel is a PHP framework for easy building of web applications. It provides a range of powerful features including: Installation: Install the Laravel CLI globally with Composer and create applications in the project directory. Routing: Define the relationship between the URL and the handler in routes/web.php. View: Create a view in resources/views to render the application's interface. Database Integration: Provides out-of-the-box integration with databases such as MySQL and uses migration to create and modify tables. Model and Controller: The model represents the database entity and the controller processes HTTP requests.

To set the shortcut keys for Sublime Text, follow these steps: Open the shortcut key settings file Key Bindings - User. Add shortcut key settings using the format { "keys": ["key combination"], "command": "command" }. Save changes. Reload the shortcut key settings for the changes to take effect.

To view the Git repository address, perform the following steps: 1. Open the command line and navigate to the repository directory; 2. Run the "git remote -v" command; 3. View the repository name in the output and its corresponding address.

There are many ways to customize a development environment, but the global Git configuration file is one that is most likely to be used for custom settings such as usernames, emails, preferred text editors, and remote branches. Here are the key things you need to know about global Git configuration files.
