/Here is the new tutorial on Installing multiple MySQL instances on a Linux server use a separate MySQL configuration file
#mysql #multiple #instnaces #linux #mysqldba
Installing Multiple MySQL Instances on Linux | MySQL DBA Tutorial | MySQL 8 DBA Tutorial – YouTube Running Multiple MySQL Instances,
Installing a single MySQL instance on a Linux machine
Script used link: https://ittutorial.org/install-multiple-mysql-instances-on-a-linux-server-use-a-separate-mysql-configuration-file/
Please Follow me on Social Media
Linkedin: https://www.linkedin.com/in/mughees-ahmed-oracle-mysql-dba-287214122/
Twitter: https://twitter.com/Mughees52
Facebook: https://www.facebook.com/Mughees52/
Deb_5752021-03-03 14:34:10
MasterZiv2021-03-03 09:22:17
You must install some VPN connection to the provider’s network and connect via it.
F.e. you can use ssh tunnel provided by PUTty.
And you’d better throw this MySQL work bench away and use some normal client
What other client would you recommend? Gui based
piterden2021-03-03 14:34:48
Each client has own cons
MasterZiv2021-03-03 14:35:50
Deb_5752021-03-03 14:34:10
What other client would you recommend? Gui based
DBeaver, Oracle SQLDeveloper , Squirell,
or even vanilla mysql
Deb_5752021-03-03 14:36:29
Dbeaver is freeware?
Deb_5752021-03-03 14:37:16
I’ll give it a try but the issue is not with workbench rather some network problem
rodrigo_tc72021-03-03 15:23:24
Deb_5752021-03-03 09:12:18
While am using putty to login to the host and then accessing mysql using mysql -uroot -p it’s working
But its not working from workbench it’s giving localhost error but mysql workbench is not even installed on localhost it is supposed to be a remote connection
change “localhost” for your remote server address on workbench.
rodrigo_tc72021-03-03 15:24:00
it should work, unless some firewall is configured on remote host
rodrigo_tc72021-03-03 15:26:45
i mean, if i’m not wrong you have a local workbench install and a remote cloud hosted mysql server
in that case, setting “localhost” in workbench would be an error… and you don’t use “localhost” to connect to that machine using putty, are you?
MasterZiv2021-03-03 15:29:41
Deb_5752021-03-03 14:36:29
Dbeaver is freeware?
Not completely, but there are two versions, community and commercial
MasterZiv2021-03-03 15:30:32
rodrigo_tc72021-03-03 15:24:00
it should work, unless some firewall is configured on remote host
it IS configured, It should be.
rodrigo_tc72021-03-03 18:28:16
MasterZiv2021-03-03 15:30:32
it IS configured, It should be.
not at all, imagine he is trying to connect localhost… no one is going to answer because the server is in, for example, 123.1.2.3
rodrigo_tc72021-03-03 18:28:58
may be just a missconfiguration and not a firewall problem, but i agree, azure must have some kind of firewall or security rules by port
MasterZiv2021-03-03 18:58:05
rodrigo_tc72021-03-03 18:28:16
not at all, imagine he is trying to connect localhost… no one is going to answer because the server is in, for example, 123.1.2.3
I meant that MySQL most probably is not accessible from the outside, with or without firewall.
rodrigo_tc72021-03-03 19:00:03
it can be something in my.cnf file as @M said before
rodrigo_tc72021-03-03 19:01:21
i’m still supposing that it’s just the hostname configuration in workbench…
piterden2021-03-03 19:59:33
rodrigo_tc72021-03-03 19:01:21
i’m still supposing that it’s just the hostname configuration in workbench…
Try ssh tunnel
davidraja james2021-03-03 21:34:56
Hi guys this is David… Greetings for MySQL family…i’m studyed mechanical engineering.. last one year I’m worked in PPO… now I’m want to IT filed..i like logical thinking..so i choosed MySQL database.. I’m learned MySQL and Linux… MySQL and Linux, is this enough for IT filed? if i want another language or not !
davidraja james2021-03-03 21:36:24
If i must to learn any other languages you know please tell Me… Thanks!!
piterden2021-03-03 22:34:18
davidraja james2021-03-03 21:36:24
If i must to learn any other languages you know please tell Me… Thanks!!
I think you should decide what are you learning for. Then try to implement your knowledge creating those things. After that you should understand yourself what is not enough for you.
davidraja james2021-03-04 07:15:27
piterden2021-03-03 22:34:18
I think you should decide what are you learning for. Then try to implement your knowledge creating those things. After that you should understand yourself what is not enough for you.
Okay thanks a lot’s Denis…. I’ll follow your instructions…
the5thyonko2021-03-04 08:49:31
Hey guys my SQL was started for us just two day’s back
the5thyonko2021-03-04 08:49:38
Can someone help me out w that
the5thyonko2021-03-04 08:49:47
I was absent for the last classes
the5thyonko2021-03-04 08:50:00
So idk how to😅
piterden2021-03-04 18:35:01
the5thyonko2021-03-04 08:50:00
So idk how to😅
Help to do what?
the5thyonko2021-03-04 18:35:26
Like the basic stuff
the5thyonko2021-03-04 18:35:45
Our classes just started but i had some problem w root password
the5thyonko2021-03-04 18:36:06
So didn’t attend properly for first classes where they tell the basic stuff
piterden2021-03-04 18:37:33
Ask the concrete question
rodrigo_tc72021-03-05 10:49:06
the5thyonko2021-03-04 18:35:26
Like the basic stuff
Use select for selects
Insert for inserts
Update for updates
And delete for deletes 😜
the5thyonko2021-03-05 10:51:03
piterden2021-03-04 18:37:33
Ask the concrete question
Teach how to do in sql 😂
the5thyonko2021-03-05 10:51:13
rodrigo_tc72021-03-05 10:49:06
Use select for selects
Insert for inserts
Update for updates
And delete for deletes 😜
Okay sir😂
MasterZiv2021-03-05 10:56:42
rodrigo_tc72021-03-05 10:49:06
Use select for selects
Insert for inserts
Update for updates
And delete for deletes 😜