Access denied for user ‘root’@’localhost’ (using password: NO)

Explanation of the problem

When using Mobius_Docker, users have encountered difficulties in getting it to function properly. Upon starting the application, the following output is repeatedly displayed:

node_1  | GET : /Mobius
node_1  |
node_1  | GET : /Mobius
node_1  | get_resource_from_url (hokpoASd) - /Mobius: 2.846ms
node_1  | get_resource_from_url (z_wpz8jS) - /Mobius: 3.322ms
node_1  | {"rsc":"5000","ri":"GET-/Mobius-{\"fu\":2,\"rcn\":1,\"rt\":3}","msg":"database error"}
node_1  | Target CSE(localhost) is not ready
node_1  | Target CSE(localhost) is not ready
node_1  | {"rsc":"5000","ri":"GET-/Mobius-{\"fu\":2,\"rcn\":1,\"rt\":3}","msg":"database error"}

Due to the indication of a database error in the message, further investigation was conducted on the database setup. Towards the end of the database setup, the following statement was found:

db_1    | 2020-01-16T15:00:53.686717Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)

Considering this error, the user is seeking a solution to address the issue. The problem has been replicated on different machines, running both Linux and Windows operating systems. The user has followed the manual installation steps from the provided guide, yet the database error persists. Attempts to resolve the “Access denied” error by implementing various solutions found on the internet have been unsuccessful.

Troubleshooting with the Lightrun Developer Observability Platform

Getting a sense of what’s actually happening inside a live application is a frustrating experience, one that relies mostly on querying and observing whatever logs were written during development.
Lightrun is a Developer Observability Platform, allowing developers to add telemetry to live applications in real-time, on-demand, and right from the IDE.

• Instantly add logs to, set metrics in, and take snapshots of live applications
• Insights delivered straight to your IDE or CLI
• Works where you do: dev, QA, staging, CI/CD, and production

Start for free today

Problem solution for: Access denied for user ‘root’@’localhost’ (using password: NO)

To resolve the issue of the “Access denied” error and address the database error in Mobius_Docker, the following steps can be taken:

1. Grant appropriate privileges to the database user:
   • Access the MySQL server using a privileged account.
   • Execute the following command to grant the necessary privileges to the user ‘root’@’localhost’:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;

1. • This grants all privileges to the ‘root’ user, allowing it to connect to the database without encountering the “Access denied” error.
2. Update the Mobius_Docker configuration:
   • Locate the configuration file or environment variables used by Mobius_Docker.
   • Update the database connection settings to ensure that the correct credentials are used to connect to the MySQL database.
   • Verify that the hostname, port, database name, username, and password are correctly specified in the configuration.
3. Restart Mobius_Docker:
   • After making the necessary changes, restart the Mobius_Docker application.
   • Monitor the logs for any further errors or issues.
   • If the database error persists or other errors occur, consult the Mobius_Docker documentation or seek assistance from the Mobius_Docker community for further troubleshooting.

By granting the appropriate privileges to the database user and ensuring the correct database connection settings are used, the “Access denied” error can be resolved, allowing Mobius_Docker to function properly.

const mobius = new MobiusClient({
  serverUrl: 'http://mobius-server.com',
  port: 8080,
});

const mobius = new MobiusClient({
  serverUrl: 'http://mobius-server.com',
  accessToken: 'your-access-token',
});

const transaction = mobius.startTransaction();
try {
  // Perform database operations within the transaction
  await transaction.query('UPDATE ...');
  await transaction.commit();
} catch (error) {
  await transaction.rollback();
  // Handle the error
}

import requests

def register_device(device_id, device_name):
    url = "https://mobius-platform.com/api/devices"
    payload = {
        "id": device_id,
        "name": device_name,
        # Additional device parameters
    }
    headers = {
        "Content-Type": "application/json",
        "Authorization": "Bearer <access_token>"
    }

    response = requests.post(url, json=payload, headers=headers)
    if response.status_code == 201:
        print("Device registered successfully.")
    else:
        print("Failed to register device. Error:", response.text)

const axios = require('axios');

async function storeSensorData(deviceId, sensorData) {
    const url = `https://mobius-platform.com/api/devices/${deviceId}/data`;
    const headers = {
        'Content-Type': 'application/json',
        'Authorization': 'Bearer <access_token>'
    };

    try {
        const response = await axios.post(url, sensorData, { headers });
        if (response.status === 201) {
            console.log('Sensor data stored successfully.');
        } else {
            console.error('Failed to store sensor data. Error:', response.data);
        }
    } catch (error) {
        console.error('An error occurred while storing sensor data:', error);
    }
}