Blog

Add a new blog
October 23

Create a MySQL user to have both local and remote access for all databases

Create a mysql user:   CREATE USER 'myUser'@'localhost' IDENTIFIED BY 'YourNewPassword';  CREATE USER 'myUser'@'%' IDENTIFIED BY 'YourNewPassword'; Then GRANT ALL ON *.* TO 'myUser'@'localhost';  GRANT ALL ON *.* TO 'myUser'@'%'; Optional: limit user to single database: GRANT ALL ON name_of_database.* TO 'myUser'@'localhost'; GRANT ALL ON name_of_database.* TO 'myUser'@'%'; Don't forget to flush:  FLUSH PRIVILEGES; Tips: optional for MySQL 8.0 if using 3rd party remote access with error "Authentication plugin 'caching_sha2_password' cannot be...

October 23

Query to enable a single user to access a remote MySQL database

Create a remote user for single DB access. GRANT ALL PRIVILEGES ON new_db.* TO 'new_db_user'@'%' IDENTIFIED BY 'YourUserPassword'; FLUSH PRIVILEGES; ...

October 23

Submitting iOS App to Apple App Store

Assuming you already enrolled in a developer license program and have an apple id. Follow these steps: open up file name with extension .xcworkspace Navigate through Project Name > Targets > General 1. Change the display name of the app, this is what the name of the app that you want the users to see in their devices. 2. Provide an unique bundle identifier of the...

October 23

How to Set Up an Apple Developer Account for my store app

Before you can have your very own iPhone app on the Apple App Store for your users to download and install into their phones, you will need to distribute your mobile app.  Once you have your apple developer account, you can submit your mobile app to the apple store for the distribution. You can offer users with a free download or charge them...

October 23

How do you generate all sizes app icons for ios and android mobile apps?

First, you should have a great design for your icon and file should be in PNG format with size 1024 x 1024 pixels.  Second, use a free online tool like https://makeappicon.com/ or http://appiconmaker.co/ to size down your icon for all different sizes for the Apple App Store or Google Play. Finally, upload them when you submit the app. ...

October 23

How to sync your cloud with Amazon AWS time by chrony?

For Ubuntu, use apt-get. For REDHAT/CENTOS, use yum.  1. Remove ntp if it is installed. 2. Install chrony and edit chrony.conf root@myserver:~# apt-get -y install chrony root@myserver:~# vim /etc/chrony/chrony.conf 3. Comment out the default servers, and add amazon server server 169.254.169.123 prefer iburst 4. Restart chrony root@myserver:~# /etc/init.d/chrony restart ...

Send us a message. We will reply as soon as we can.