Миграция с windows на ubuntu

разрабатываю приложения словаря для себя. приложение прекрасно работает на windows 10. суть приложения клиент - reactjs (с ним проблем нет), работает в windows 10 и в Ubuntu 22.04.3 LTS. с server - проблемы. сервер на express с подключение к базе данных MySQl через sequelize. база данных создана, служба MySql активна , пароль для рута и для базы данных одинаковый. но при запуске сервера на Ubuntu у меня ошибка. в целом всё приложение работает в windows 10 без ошибок и так как я того хочу. `

   1] ConnectionError [SequelizeConnectionError]: Access denied for user 'root'@'localhost'
    [1]     at ConnectionManager.connect (/root/dictionary/server_for_dictionary/node_modules/sequelize/lib/dialects/mysql/connection-manager.js:102:17)
    [1]     at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    [1]     at async ConnectionManager._connect (/root/dictionary/server_for_dictionary/node_modules/sequelize/lib/dialects/abstract/connection-manager.js:222:24)
    [1]     at async /root/dictionary/server_for_dictionary/node_modules/sequelize/lib/dialects/abstract/connection-manager.js:174:32
    [1]     at async ConnectionManager.getConnection (/root/dictionary/server_for_dictionary/node_modules/sequelize/lib/dialects/abstract/connection-

    manager.js:197:7)
        [1]     at async /root/dictionary/server_for_dictionary/node_modules/sequelize/lib/sequelize.js:305:26
        [1]     at async Sequelize.authenticate (/root/dictionary/server_for_dictionary/node_modules/sequelize/lib/sequelize.js:457:5)
        [1]     at async start (/root/dictionary/server_for_dictionary/dist/index.js:23:9) {
        [1]   parent: Error: Access denied for user 'root'@'localhost'
        [1]       at Packet.asError (/root/dictionary/server_for_dictionary/node_modules/mysql2/lib/packets/packet.js:728:17)
        [1]       at ClientHandshake.execute (/root/dictionary/server_for_dictionary/node_modules/mysql2/lib/commands/command.js:29:26)
        [1]       at Connection.handlePacket (/root/dictionary/server_for_dictionary/node_modules/mysql2/lib/connection.js:478:34)
        [1]       at PacketParser.onPacket (/root/dictionary/server_for_dictionary/node_modules/mysql2/lib/connection.js:97:12)
        [1]       at PacketParser.executeStart (/root/dictionary/server_for_dictionary/node_modules/mysql2/lib/packet_parser.js:75:16)
        [1]       at Socket.<anonymous> (/root/dictionary/server_for_dictionary/node_modules/mysql2/lib/connection.js:104:25)
        [1]       at Socket.emit (node:events:514:28)
        [1]       at addChunk (node:internal/streams/readable:545:12)
        [1]       at readableAddChunkPushByteMode (node:internal/streams/readable:495:3)
        [1]       at Readable.push (node:internal/streams/readable:375:5) {
        [1]     code: 'ER_ACCESS_DENIED_NO_PASSWORD_ERROR',
        [1]     errno: 1698,
        [1]     sqlState: '28000',
        [1]     sqlMessage: "Access denied for user 'root'@'localhost'",
        [1]     sql: undefined
        [1]   },
        [1]   original: Error: Access denied for user 'root'@'localhost'
        [1]       at Packet.asError (/root/dictionary/server_for_dictionary/node_modules/mysql2/lib/packets/packet.js:728:17)
        [1]       at ClientHandshake.execute (/root/dictionary/server_for_dictionary/node_modules/mysql2/lib/commands/command.js:29:26)
        [1]       at Connection.handlePacket (/root/dictionary/server_for_dictionary/node_modules/mysql2/lib/connection.js:478:34)
        [1]       at PacketParser.onPacket (/root/dictionary/server_for_dictionary/node_modules/mysql2/lib/connection.js:97:12)
        [1]       at PacketParser.executeStart (/root/dictionary/server_for_dictionary/node_modules/mysql2/lib/packet_parser.js:75:16)
        [1]       at Socket.<anonymous> (/root/dictionary/server_for_dictionary/node_modules/mysql2/lib/connection.js:104:25)
        [1]       at Socket.emit (node:events:514:28)
        [1]       at addChunk (node:internal/streams/readable:545:12)
        [1]       at readableAddChunkPushByteMode (node:internal/streams/readable:495:3)
        [1]       at Readable.push (node:internal/streams/readable:375:5) {
        [1]     code: 'ER_ACCESS_DENIED_NO_PASSWORD_ERROR',
        [1]     errno: 1698,
        [1]     sqlState: '28000',
        [1]     sqlMessage: "Access denied for user 'root'@'localhost'",
        [1]     sql: undefined
        [1]   }
        [1] }

пример кода подключения к дб:

const sequelize: Sequelize = new Sequelize('dictionary', 'root', '11111', {
        dialect: "mysql",
        host: 'localhost',
        port: 3306,
    });

собственно сам сервер

const start = async () => {
    try {
        await sequelize.authenticate();
        await sequelize.sync();
        app.listen(port, () => {
            console.log(`Server running at http://localhost:${port}`);
        });
    } catch (e) {
        console.log(e);
    }
};

start();

Собственно сам вопрос ,что мне делать и куда бежать? как исправить ошибку подключения к базе данных? P.s. извините , что дал много ненужной информации.


Ответы (0 шт):