Online Reservation System:
Software, database & hosting

Can I access my MySQL database externally, e.g. from my PC?

Question: 

Searching …

 

Unfortunately nothing found on "".

Premium support for Bitpalace web hosting customers only!

 from Madagascar: +49 30 32 70 18 92, Fax (in Germany) +49 30 32 70 18 91

service@bitpalast.net 

Skype: bitpalast

One moment please … your browser is loading the page.

 

 

Symptom

Normally only your website accesses the MySQL database of your Bitpalace Small Enterprise Server. However, now you want to access the database from an external system, too. Maybe you run an inventory system that stores its data to your MySQL database. Or maybe you own an online shop software that features a backend for your computer where you manage your products. That software ought to be able to communicate with the MySQL database on your Bitpalace Small Enterprise Server.

 

Solution

1. Log-in to your Linux console by SSH.

2. By default MySQL only listens to database port messages on the local host. If you want to access MySQL from external systems, you must remove this binding. Edit the /etc/my.cnf file

vi /etc/my.cnf

Change the line
bind-address=127.0.0.1

to
# bind-address=127.0.0.1

Save the changes:
[ESC] + :wq! + [ENTER]

3. Stop and start the MySQL service, so that the changes will be read:

FreeBSD:
/usr/local/etc/rc.d/mysql-server stop
/usr/local/etc/rc.d/mysql-server start

Linux:
service mysqld restart

4. Log-in to the MySQL console:

mysql -u root -p

5. Grant a new or existing user privileges to access the database from any external servers:

grant all privileges on [databasename].* to [loginname]@"%" identified by [password]

Instead of [databasename], [loginname] and [password] enter values of your choice. The placeholder "%" means "from any IP address ". If you want to limit access to a specific subnet, you can also enter the subnet address. For instance, if you want to limit access to the subnet "213.198.*.*", use this command:

grant all privileges on [databasename].* to [loginname]@"213.198.%" identified by [password]

6. Activate the new login credentials:

flush privileges;

7. Exit the MySQL console:

exit;

 

Overview of frequently asked questions 

 

 

 


 

Additional Services

Cheap web space for less than 1 US$/month 

Starter Server: Affordable web server from  2.25 US$ () /month with PHP, database and many more 

Software development: Development of database applications, programming and revision of computer programs & scripts  18.90 US$ () /hour 

 

FAQ – frequently asked questions 

 

Reservation system (reservation server) in selected countries

Colombia

Austria

Canada

Guinea

Panama

Cuba

Lesotho

Antigua and Barbuda

Paraguay

Peru

Jordan

Argentina

Costa Rica

Australia

Germany

Bahamas

Liberia

Barbados

Belize

Philippines

Uganda

Honduras

Puerto Rico

Malta

Bolivia

Botswana

Marshall Islands

Chile

Rwanda

India

Mauritius

Saint Kitts and Nevis

Saint Vincent and the Grenadines

Zambia

Saint Lucia

Mexico

Samoa

Jamaica

Micronesia, Federated States of

Switzerland

Dominican Republic

Malawi

Seychelles

Namibia

Kenya

Dominican Republic

Nauru

Sierra Leone

New Zealand

Ecuador

Singapore

El Salvador

Fiji

Solomon Islands

Gambia

Spain

Nicaragua

Sudan

Nigeria

Swaziland

South Africa

Pakistan

Palau

Tanzania, United Republic of

Kiribati

Ghana

Tonga

Trinidad and Tobago

Guyana

Tuvalu

Uruguay

Papua New Guinea

Venezuela

United States

Ireland

Cameroon

Grenada

Guatemala

United Kingdom

Zimbabwe

 

"Reservation System": reservation software, reservation program, reservation application, software for maintaining reservations, reservation server, schedule, scheduler, occupancy plan, timetable, lending software / issuing desk administration, vehicle pool, conference room schedule.

  from Madagascar: +49 30 32 70 18 92 •  GmbH, Sensburger Allee 27, D-14055 Berlin (Germany)
Your purchase is tax-free, because you order from a non-EU country. © 2024  GmbH. All rights reserved. and the logo are registered trademarks of GmbH. For photo credits see imprint.

Imprint Privacy policy Sitemap