converting my to SQL database

[jackk556]

hello, so I keep getting an error when converting MySQLlite to My SQL DATABASE,

 

 

 

 

 

 

Error - Can't connect to MySQL server on 'localhost' (10061): No connection could be made because the target machine actively refused it 127.0.0.1:3306

[Rads]

probably a firewall issue maybe I've been up the port 3306 will help

 

Generally restricting MySQL access to an ip address is a good idea. There can be some security concerns but a good firewall should mitigate some of them

[Dennis]

Are you sure MySQL is running?

You'll need to manually install and configure a MySQL server.

[Davinel17]

i can help you i got the same problem , the only way i found to succeed ( not found the support help me ) is to create your database with cmd line

 

open mysql command line 5.7

Write this cmd:

CREATE DATABASE tcadmin;

 

CREATE USER 'tcadmin'@'%' IDENTIFIED WITH mysql_native_password BY 'PASSWORDHERE';

 

GRANT ALL PRIVILEGES ON tcadmin.* TO 'tcadmin'@'%';

 

Honestly i try alot of time and its the only way i succeed on win 10 ,windows server 2012 and 2019

[Dennis]

the only way i found to succeed ( not found the support help me ) is to create your database with cmd line

Because that is the only way to do it. You will need to create the database before you can use it :-)

[Davinel17]

nha i mean , if i create it by mysql workbench it did't work

[Dennis]

It must mean that you've created the database user with the incorrect permissions to the database.

 

Whether you setup the database and user through MySQL Workbench, phpMyAdmin or CLI is the same - it's just a matter of preference :-)