After the initial installation of 7.4.0, the MySQL client prompts for a password upon login

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 首次安装7.4.0后,使用mysql客户端登录提示使用密码

| username: Aionn

[TiDB Usage Environment] Local machine testing
[TiDB Version] v7.4.0
[Reproduction Path] Follow the documentation here to execute the installation and deployment: TiDB 数据库快速上手指南 | PingCAP 文档中心
[Encountered Issue: Problem Phenomenon and Impact] Using the mysql command to log in prompts a permission password issue
[Resource Configuration] Go to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
[Attachments: Screenshots/Logs/Monitoring]
The document is as follows:

The operation is executed as follows:

| username: zhanggame1 | Original post link

The password was entered incorrectly. During deployment, the password should have been displayed on the screen. You should copy it from there. If it wasn’t displayed, it means it’s empty.

| username: Aionn | Original post link

The issue has been identified and resolved, thank you.

| username: zhanggame1 | Original post link

When you get to this step:
tiup cluster start cluster-name --init
Adding --init will output a password for you. If you don’t add it, the root password will be empty.

| username: Aionn | Original post link

Here on macOS

| username: 芮芮是产品 | Original post link

Yes, it needs to be changed.

| username: Fly-bird | Original post link

After installation, the init initialization already has a password.

| username: 路在何chu | Original post link

Started learning how to generate passwords in MySQL.

| username: 舞动梦灵 | Original post link

There is no -p. The -p password parameter is missing, and after deployment, some have a default empty password, while others automatically output a password based on the -init deployment parameter.

| username: Aionn | Original post link

The idea is very correct, I also found this and it solved the problem.

| username: Aionn | Original post link

The TiDB client can log in, but the MySQL client cannot.

| username: Aionn | Original post link

What I mean is that the official documentation here should also include the -p parameter.

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.