Ggtcf

Is it legal for company to use my work email to pretend I still work there?

GPS Rollover on Android Smartphones

Suffixes -unt and -ut-

Type 1 Error & Type 2 Error's pregnancy test analogy: is it legit?

Writing rule which states that two causes for the same superpower is bad writing

Is the month field really deprecated?

Modeling an IPv4 Address

How do we improve the relationship with a client software team that performs poorly and is becoming less collaborative?

Why linear maps act like matrix multiplication?

Basic combinations logic doubt in probability

What typically incentivizes a professor to change jobs to a lower ranking university?

Can you tell me why doing scalar multiplication of a point on a Elliptic curve over a finite field gets to a point at infinity?

Shell script not opening as desktop application

What do you call a Matrix-like slowdown and camera movement effect?

Relation between Frobenius, spectral norm and sum of maxima

Do Phineas and Ferb ever actually get busted in real time?

How is the claim "I am in New York only if I am in America" the same as "If I am in New York, then I am in America?

The iconography of Laddu Gopal's soles

Why are 150k or 200k jobs considered good when there are 300k+ births a month?

If Manufacturer spice model and Datasheet give different values which should I use?

TGV timetables / schedules?

How much RAM could one put in a typical 80386 setup?

Why did the Germans forbid the possession of pet pigeons in Rostov-on-Don in 1941?

How did the USSR manage to innovate in an environment characterized by government censorship and high bureaucracy?

MySQL Server 8.0 remote database

MySQL remote server connection failed w NavicatHow do I quickly rename a MySQL database (change schema name)?Which MySQL data type to use for storing boolean valuesHow to output MySQL query results in CSV format?How do I connect to a MySQL Database in Python?Should I use the datetime or timestamp data type in MySQL?How to get a list of MySQL user accountsHow to reset AUTO_INCREMENT in MySQL?How to get the sizes of the tables of a MySQL database?How to import an SQL file using the command line in MySQL?Django install/deploy with mysql

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

-1

I am very frustrated that I am trying this from over 5 days.
I need to create database on my PC that has to be visible for all other PCs in the same LAN.

I tried with XAMPP - Apache + MySQL - no result even after reading all articles from first 2 pages of Google and watching many youtube clips.
Now I am trying with MySQL Server 8.0 on my PC. I tried again all of Google first pages stuff without result. How can I do that?

I know that this has been asked many times here but there is no complex solution at all.

Does anybody of you have tutorial that is tested nowadays and it is working?

mysql remote-access

share|improve this question

edited Mar 9 at 3:36

Book Of Zeus

45.9k12161162

asked Mar 8 at 9:34

Borislav StefanovBorislav Stefanov

266

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  There are a few basic steps you need to check: is your firewall open? Is your db configured to accept tcp traffic? Remotely? Etc...
  
  – David Brossard
  Mar 9 at 3:39
  

  
  
  
  

add a comment | 

-1

I am very frustrated that I am trying this from over 5 days.
I need to create database on my PC that has to be visible for all other PCs in the same LAN.

I tried with XAMPP - Apache + MySQL - no result even after reading all articles from first 2 pages of Google and watching many youtube clips.
Now I am trying with MySQL Server 8.0 on my PC. I tried again all of Google first pages stuff without result. How can I do that?

I know that this has been asked many times here but there is no complex solution at all.

Does anybody of you have tutorial that is tested nowadays and it is working?

mysql remote-access

share|improve this question

edited Mar 9 at 3:36

Book Of Zeus

45.9k12161162

asked Mar 8 at 9:34

Borislav StefanovBorislav Stefanov

266

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  There are a few basic steps you need to check: is your firewall open? Is your db configured to accept tcp traffic? Remotely? Etc...
  
  – David Brossard
  Mar 9 at 3:39
  

  
  
  
  

add a comment | 

I am very frustrated that I am trying this from over 5 days.
I need to create database on my PC that has to be visible for all other PCs in the same LAN.

I tried with XAMPP - Apache + MySQL - no result even after reading all articles from first 2 pages of Google and watching many youtube clips.
Now I am trying with MySQL Server 8.0 on my PC. I tried again all of Google first pages stuff without result. How can I do that?

I know that this has been asked many times here but there is no complex solution at all.

Does anybody of you have tutorial that is tested nowadays and it is working?

mysql remote-access

share|improve this question

edited Mar 9 at 3:36

Book Of Zeus

45.9k12161162

asked Mar 8 at 9:34

Borislav StefanovBorislav Stefanov

266

share|improve this question

edited Mar 9 at 3:36

Book Of Zeus

45.9k12161162

asked Mar 8 at 9:34

Borislav StefanovBorislav Stefanov

266

share|improve this question

edited Mar 9 at 3:36

Book Of Zeus

45.9k12161162

asked Mar 8 at 9:34

Borislav StefanovBorislav Stefanov

266

edited Mar 9 at 3:36

Book Of Zeus

45.9k12161162

edited Mar 9 at 3:36

Book Of Zeus

45.9k12161162

asked Mar 8 at 9:34

Borislav StefanovBorislav Stefanov

266

asked Mar 8 at 9:34

Borislav StefanovBorislav Stefanov

266

2 Answers
2

active

oldest

votes

0

you should provide more details like the error message you get when connecting to the remote mysql server, anyway, to allow remote access, here is a checklist you need to go through:

1. 
   

   grant permission, mysql by default only allow access from localhost(127.0.0.1), to allow other ip access:
   // replace root for the username, '123456' for the password
   grant all privileges on . to 'root'@'%' identified by '123456';

   
   
   

   flush privileges;

   
   



2. check your server firewall settings to allow your mysql through port 3306(default)




3. others:
   for linux server I think you also need to comment out "bind address" in your mysql config file;
   some other issues for example your mysql client autodetect the wrong timezone, you may need to manually set it;
   check your inbound rule on your client pc;
   etc.

my suggestion for you, don't just google around blindly, think about it logically first, sometimes there is no direct answer

share|improve this answer

answered Mar 10 at 3:24

LIU YUELIU YUE

16118

add a comment | 

0

The problem was in connection String.

static final String USERNAME="[username]";
static final String PASSWORD="[password]";
static final String CONN_STRING="jdbc:mysql://[ip-address]:[port]/[database-name]";

So as LIU YUE suggested I just granted access for this username. The problem was that my other computer has a different name.

share|improve this answer

answered Mar 11 at 13:33

Borislav StefanovBorislav Stefanov

266

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55060341%2fmysql-server-8-0-remote-database%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

you should provide more details like the error message you get when connecting to the remote mysql server, anyway, to allow remote access, here is a checklist you need to go through:

1. 
   

   grant permission, mysql by default only allow access from localhost(127.0.0.1), to allow other ip access:
   // replace root for the username, '123456' for the password
   grant all privileges on . to 'root'@'%' identified by '123456';

   
   
   

   flush privileges;

   
   



2. check your server firewall settings to allow your mysql through port 3306(default)




3. others:
   for linux server I think you also need to comment out "bind address" in your mysql config file;
   some other issues for example your mysql client autodetect the wrong timezone, you may need to manually set it;
   check your inbound rule on your client pc;
   etc.

my suggestion for you, don't just google around blindly, think about it logically first, sometimes there is no direct answer

share|improve this answer

answered Mar 10 at 3:24

LIU YUELIU YUE

16118

add a comment | 

0

you should provide more details like the error message you get when connecting to the remote mysql server, anyway, to allow remote access, here is a checklist you need to go through:

1. 
   

   grant permission, mysql by default only allow access from localhost(127.0.0.1), to allow other ip access:
   // replace root for the username, '123456' for the password
   grant all privileges on . to 'root'@'%' identified by '123456';

   
   
   

   flush privileges;

   
   



2. check your server firewall settings to allow your mysql through port 3306(default)




3. others:
   for linux server I think you also need to comment out "bind address" in your mysql config file;
   some other issues for example your mysql client autodetect the wrong timezone, you may need to manually set it;
   check your inbound rule on your client pc;
   etc.

my suggestion for you, don't just google around blindly, think about it logically first, sometimes there is no direct answer

share|improve this answer

answered Mar 10 at 3:24

LIU YUELIU YUE

16118

add a comment | 

you should provide more details like the error message you get when connecting to the remote mysql server, anyway, to allow remote access, here is a checklist you need to go through:

1. 
   

   grant permission, mysql by default only allow access from localhost(127.0.0.1), to allow other ip access:
   // replace root for the username, '123456' for the password
   grant all privileges on . to 'root'@'%' identified by '123456';

   
   
   

   flush privileges;

   
   



2. check your server firewall settings to allow your mysql through port 3306(default)




3. others:
   for linux server I think you also need to comment out "bind address" in your mysql config file;
   some other issues for example your mysql client autodetect the wrong timezone, you may need to manually set it;
   check your inbound rule on your client pc;
   etc.

my suggestion for you, don't just google around blindly, think about it logically first, sometimes there is no direct answer

share|improve this answer

answered Mar 10 at 3:24

LIU YUELIU YUE

16118

share|improve this answer

answered Mar 10 at 3:24

LIU YUELIU YUE

16118

answered Mar 10 at 3:24

LIU YUELIU YUE

16118

answered Mar 10 at 3:24

LIU YUELIU YUE

16118

0

The problem was in connection String.

static final String USERNAME="[username]";
static final String PASSWORD="[password]";
static final String CONN_STRING="jdbc:mysql://[ip-address]:[port]/[database-name]";

So as LIU YUE suggested I just granted access for this username. The problem was that my other computer has a different name.

share|improve this answer

answered Mar 11 at 13:33

Borislav StefanovBorislav Stefanov

266

add a comment | 

0

The problem was in connection String.

static final String USERNAME="[username]";
static final String PASSWORD="[password]";
static final String CONN_STRING="jdbc:mysql://[ip-address]:[port]/[database-name]";

So as LIU YUE suggested I just granted access for this username. The problem was that my other computer has a different name.

share|improve this answer

answered Mar 11 at 13:33

Borislav StefanovBorislav Stefanov

266

add a comment | 

The problem was in connection String.

static final String USERNAME="[username]";
static final String PASSWORD="[password]";
static final String CONN_STRING="jdbc:mysql://[ip-address]:[port]/[database-name]";

So as LIU YUE suggested I just granted access for this username. The problem was that my other computer has a different name.

share|improve this answer

answered Mar 11 at 13:33

Borislav StefanovBorislav Stefanov

266

share|improve this answer

answered Mar 11 at 13:33

Borislav StefanovBorislav Stefanov

266

answered Mar 11 at 13:33

Borislav StefanovBorislav Stefanov

266

answered Mar 11 at 13:33

Borislav StefanovBorislav Stefanov

266