Web site admin panel software

Web site administration may be a complex management issue sometimes expecially if you want a totally dynamic custom content management system for your web site. I'm a backend web developer and use my own admin panel software to provide cms for my clients worldwide. Some of my clients use a ready made high quality template/theme for their web projects while some prefer having a custom web design and user interface according to their requirements.

Actually i'm not involved in the design and ui parts of web projects but i do the back end works like database development, providing an administration panel for content management and also converting web site front end to a dynamic complete web site project. In the video below you can find a demo of my admin panel software being used on a sample project.

If you would like to have your web template turned into a dynamic web site using this website admin panel, you can contact me using the contact form below to get an offer for your project.

Mysql connection problems and setting root password

Recently i had to make a fresh install to my Linux machine. While installing software and packages i need regularly i had some problems with mysql server. I had errors while trying to connect as root user. Here i will note the steps for solving the problem and resetting mysql root password step by step.
(Please enter/copy the commands one by one. Do not copy all commands at once and paste to terminal. Terminal shortcut is Ctrl Alt T)

If you had edited mysql configuration and would like to start from the beginning without confusion, you may prefer to purge your mysql server installation and install again using these commands:

sudo apt purge mysql-server
sudo apt-get install mysql-server

First i opened a terminal window and entered the following commands. I used the first two commands because i had an error about permission problem for /var/run/mysqld directory while starting mysql server.

sudo mkdir -p /var/run/mysqld
sudo chown mysql:mysql -R /var/run/mysqld
sudo /etc/init.d/mysql stop
sudo mysqld_safe --skip-grant-tables &
(press enter)
mysql -uroot

You should be able to access mysql query terminal now. Enter the following mysql commands:

use mysql;
update user set authentication_string=PASSWORD("yourrootpassword") where User='root';
update user set plugin="mysql_native_password" where User='root';
flush privileges;
quit;

When you turn to terminal enter these commands for testing your connection.

sudo /etc/init.d/mysql stop
sudo /etc/init.d/mysql start # reset mysql
mysql -u root -p

When your connection is ok you can also test using your mysql admin software like phpmyadmin, adminer etc. to be sure that you can connect on web too. If you get errors about missing plugins etc. make sure that you have installed mysql module for php and restart apache server.

Api key instructions explained

While using GPS Coordinates Finder Pro mobile application, you need an api key for the application function properly. Instructions on how to get an api key for your account is explained with details at this page:
http://ezg-apps.blogspot.com/p/get-your-api-key-for-gpscf-pro.html

We advise you to first get your api key before purchase of pro version application. However if you have difficulty with completing the steps you can contact us for help. You can also prefer to get a refund for your purchase if you don't want to use the application. You can find details about refund process at this page:
http://ezg-apps.blogspot.com/p/refund.html

GPSCF Pro version updated and published again

GPSCF Pro versions for both iOS and Android have been updated to fix the previous problem and have been published again on AppStore and Google Play. In this version you need an api key to use pro version applications. You can read this article describing how you can obtain an api key for your use of GPSCF Pro without problem:

https://ezg-apps.blogspot.com/p/get-your-api-key-for-gpscf-pro.html

GPSCF Android v1.5.1 update

GPSCF Android version 1.5.1 update has been published on Google Play.

In this version the search function (which was disabled temporarily before) has been enabled again.

Thanks for your patience!

GPSCF Pro iOS version bugfix update

The problem about map for GPSCF Pro iOS version has been fixed and a new version has been published on AppStore. Thanks for your patience.

Announcement about missing search feature in latest GPSCF (android version)

The latest update for GPSCF android version has the previous search function disabled temporarily for development reasons. The search function will be ready again when we complete development upgrade and published in google play and app store as soon as possible. (The pro version is not affected by this change)

Sorry for any problem caused by this change in this version.

Best regards