Sam-pointer - Tin tổng hợp hay nhất trong ngày 24h qua
  • Home
  • Công Nghệ
  • Ẩm Thực
  • Du Lịch
  • Làm Đẹp
Saturday, August 6, 2022
  • Home
  • Công Nghệ
  • Ẩm Thực
  • Du Lịch
  • Làm Đẹp
No Result
View All Result
Sam-pointer - Tin tổng hợp hay nhất trong ngày 24h qua
No Result
View All Result

MySQL – Remote Access to MySQL Server on Linux CentOS 6.3 Part 1

July 14, 2020



In this tutorial I talk you through installing and configuring a MySQL server to allow remote access on Linux using CentOS 6.3.

So first, download and install the mysql server: yum install mysql mysql-server

Next make it so as the mysql server with be running on server startup, issue the following command:

chkconfig mysqld on

Next start the mysqld service

service mysqld start

Next run the command /usr/bin/mysql_secure_installation in order to set the root password and to delete other users and ultimately to stop the root user from having remote access.

Then you can access the mysql server, to make a new user, which you can login in as rather than using the root user all of the time.

We then editted the /etc/my.cnf, to allow the server to be access remotely only on the address of 10.10.10.30, which was the static ip address of this machine which we install the mysql server on.

We add the following line to this file below the area which is [mysqld]
bind-address=10.10.10.30

Note: this ip address needs to be static ip address of this single machine.

Next we added a rule to the firewall by editting the /etc/sysconfig/iptables file, by adding the following line to it, above the ssh line:

-A INPUT -p tcp -m state –state NEW,ESTABLISHED -m tcp –dport 3306 -j ACCEPT

Once you have save and closed this file, restart or reload the iptables:

service iptables restart

Potentially, this is the server ready to be used remotely, although you are still required to add a user which has the correct privileges:

No more space available…best just watch the video!!!!

#davidsvideos

Nguồn: https://sam-pointer.com/

Xem thêm bài viết khác: https://sam-pointer.com/cong-nghe/

Xem thêm Bài Viết:

  • Ưu Và Nhược Điểm Của Các Phần Mềm Quản Lý Dự Án
  • Chipset B550 – Kẻ thay thế X570 với mức giá MỀM hơn rất nhiều
  • Which SSD Is Better – Samsung 860 PRO vs 850 PRO SSD
  • Installing Samsung Evo 860 250Gb SSD in G41 Board | Unbox, Review & how to install OS in ssd + HDD
  • Samsung 860 EVO Review and Installation
admin

admin

Related Posts

Ưu Và Nhược Điểm Của Các Phần Mềm Quản Lý Dự Án
Công Nghệ

Ưu Và Nhược Điểm Của Các Phần Mềm Quản Lý Dự Án

August 3, 2022

Ngày nay, khi công nghệ phát triển mạnh mẽ, ngày càng nhiều công ty tận dụng các giải pháp quản lý dự án trong hoạt động kinh doanh của mình, từ việc lập kế hoạch, lập lịch trình đến...

Chipset B550 được đánh giá rất cao 
Công Nghệ

Chipset B550 – Kẻ thay thế X570 với mức giá MỀM hơn rất nhiều

July 26, 2021

Con Chipset B550 AMD do chính Asmedia thiết kế là các bo mạch chủ để thiết kế con chip này được phát hành vào năm 2020. Gần một năm sau khi AMD X570 ra mắt thì B550 mới xuất...

Which SSD Is Better – Samsung 860 PRO vs 850 PRO SSD
Công Nghệ

Which SSD Is Better – Samsung 860 PRO vs 850 PRO SSD

July 11, 2021

Samsung 860 PRO SSD US: UK: CA: DISPLATE METAL POSTERS Awesome graphic prints made out of metal: 10% Off Discount Code: HAURJIE10 FOLLOW ME Twitter | Facebook | Instagram - @haurjie MY WORKSTATION (US Links) CPU: GPU: PSU: RAM:...

Installing Samsung Evo 860 250Gb SSD in G41 Board | Unbox, Review & how to install OS in ssd + HDD
Công Nghệ

Installing Samsung Evo 860 250Gb SSD in G41 Board | Unbox, Review & how to install OS in ssd + HDD

July 11, 2021

Installing Samsung Evo 860 250Gb SSD in G41 Board | Unbox, Review & how to install OS in ssd + HDD] Buy on amazon india - // amazon USA - flipkart - ebay india ...

Comments 26

  1. akusate says:
    2 years ago

    5:50 i put in the password and it says access denied

    Reply
  2. Sanita Minimalist says:
    2 years ago

    thank you for your videos

    Reply
  3. robson allen chirara says:
    2 years ago

    Great video. I have been cracking my head trying to figure out this. Thank you very much. Definitely subscribing to your channel.

    Reply
  4. bhagat sarma says:
    2 years ago

    This video helped me a lot for configure my server that i rented from www.datasoft.ws
    Please upload more videos.

    Reply
  5. Thembelani Msongelwa says:
    2 years ago

    Edit your title it's misleading – get to the point according to your title

    Reply
  6. Wasiq Saeed says:
    2 years ago

    where is iptables file on ubunutu 16

    Reply
  7. Chip Sun says:
    2 years ago

    Thank you David!

    Reply
  8. Knicolas Booth says:
    2 years ago

    I wish you people will STOP USING Freakin LOCALHOST and start giving people examples with a laptop from a NON HOSTING LOCATION into a web page's sql database. i.e. whatsmyip.com and using that to connect remotely….nothing seems to work

    Reply
  9. masa who says:
    2 years ago

    OMG THANK YOU!

    Reply
  10. Anamika Singh says:
    2 years ago

    very helpful tutorial … thanks. 🙂

    Reply
  11. Eliot Jordon says:
    2 years ago

    how does this work with phpmyadmin? I have my local machine .100, a webserver .101, and a mysql db .102.
    phpmyadmin is installed on the webserver .101. from my local machine .100 I want to access mysql db through phpmyadmin, so on the local machine I type .101/phpmyadmin in a browser and get the phpmyadmin login page, but can't login. I get an error. should the username be the remote webserver username that was created in mysql (user@.101)?

    Reply
  12. SIDΞKICK says:
    2 years ago

    i don't understand. i thought you would just run the MySQL Server Instance Config Wizard and allow the PORT then allow root access. then from the client machines you just need the ip address of the server and you must know the password to connect.

    Reply
  13. Jeff Herdzina says:
    2 years ago

    Why not just SSH into the server and access MYSQL that way?

    Reply
  14. shuhain suhail says:
    2 years ago

    This tutorial was excellent. really helpful thank you keep doing

    Reply
  15. Behnam Anisi says:
    2 years ago

    Hey @Thornweb Thanks for the video, bu i am using Centos 7 and i need to install Mysql 5.5.28 on it, how can i do that? it's important that the sql version is the exact same. thanks

    Reply
  16. Kathy Z says:
    2 years ago

    This is everything I'm looking for. Thanks heaps for making this tutorial!

    Reply
  17. Renato Godoy says:
    2 years ago

    Buen vídeo, muy bien explicado. Gracias!

    Reply
  18. Rick Hammer says:
    2 years ago

    This video is awesome, helped me learn and solve some issues I was having!

    Reply
  19. Ben Jurevicius says:
    2 years ago

    This tutorial was excellent.  Exactly the info I needed to get remote connect to MySQL.  Cheers!

    Reply
  20. Luis Ronquillo says:
    2 years ago

    4 days typing all the posible fucking commands on my dedicated server with Debian 7 and ISPConfig 3. Finally I found this video and now MySQL database can be accessed remotely. Thanks man, this really help me. 😀

    Reply
  21. vivek kumar says:
    2 years ago

    Hi thanks for this great video,
    I have been given an assignment on accessing mysql db that is installed on a vm which has ubuntu, from pycharm which is installed on other vm that also has ubuntu. what are the details that i have to give in to connect the database to the pycharm. Thanks in advance.

    Reply
  22. WarisTechTips says:
    2 years ago

    hello, 
    I've been assigned to create a lamp cluster and install wordpress in my class. but my instructor has told us to install MYSQL in server A and install PHP,APACHE,WORDPRESS on server B. 
    i've installed all packages on both servers. but the problem is  when i go to the web browser and insert my ip address it says my php is missing a MYSQL extension
    (server B). 
    i did everything you instructed but when i got to the part where you need to put the command on Server B
    #mysql  -u james -h 10.0.0.23 -p 
    it says 
    bash: mysql: command not found 
    i personally don't think its possible for this assignment to work without server B also having mysql. 
    what do you think i should, is this possible and if so how because I've been trying for almost 2 weeks now. you would really be helping me out on this.
    thank you so much in advance. 

    Reply
  23. Dennis Mote says:
    2 years ago

    I'd like to setup remote SQL access for anywhere… I attempted

    mysql> create user 'username'@'%' identified by 'password';
    ERROR 1396 (HY000): Operation CREATE USER failed for 'username'@'%'

    as well as  

    mysql> create user 'username'@'*' identified by 'password';
    Query OK, 0 rows affected (0.00 sec)

    ^^ This one seemed to actually do something, but I still get a connection error

    Any ideas?

    Reply
  24. Niels says:
    2 years ago

    How can you open the root@………. Window?

    Reply
  25. xuantru tru says:
    2 years ago

    step bind-address=0.0.0.0
    service mysqld restart 
    Starting mysqld:                                           [FAILED]
    help me

    Reply
  26. Rock Vill says:
    2 years ago

    Thanks Dude it helped me to configure mysql remotely. I was searching for this from past one week. Thanks a lot.

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Xem Thêm

[ADR! Review] Trải nghiệm phòng Tổng Thống tại Vinpearl HaLong resort

[ADR! Review] Trải nghiệm phòng Tổng Thống tại Vinpearl HaLong resort

July 13, 2020
[Bí kíp du lịch] Cách săn vé máy bay giá rẻ chặng nội địa: Đà Nẵng, Hà Nội, Phú Quốc…

[Bí kíp du lịch] Cách săn vé máy bay giá rẻ chặng nội địa: Đà Nẵng, Hà Nội, Phú Quốc…

July 8, 2020
[Hướng dẫn] Cách sử dụng Voucher Vinpearl khi đặt phòng khách sạn

[Hướng dẫn] Cách sử dụng Voucher Vinpearl khi đặt phòng khách sạn

July 7, 2020
#3tr988 Tour du lịch Hà Giang – Lũng Cú – Đồng Văn – Mã Pì Lèng – Sông Nho Quế 4N3Đ Gồm vé máy bay

#3tr988 Tour du lịch Hà Giang – Lũng Cú – Đồng Văn – Mã Pì Lèng – Sông Nho Quế 4N3Đ Gồm vé máy bay

July 15, 2020
#QVĐVN – Tập 3 – Xuyên Rừng Đước Đất Mũi Cà Mau (với diễn viên Duy Luân)

#QVĐVN – Tập 3 – Xuyên Rừng Đước Đất Mũi Cà Mau (với diễn viên Duy Luân)

July 16, 2020
10 Điều Thú Vị Về Campuchia

10 Điều Thú Vị Về Campuchia

July 17, 2020
  • Chính Sách Bảo Mật
  • Liên Hệ

Copyright © 2020 By sam-pointer

No Result
View All Result
  • Chính Sách Bảo Mật
  • Liên Hệ
  • Sam-pointer – Tin tổng hợp hay nhất trong ngày 24h qua