Mysql
-
September 18, 2022
The default MySQL 8 auth plugin is
auth_socket
, which causes the error "SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client" when an application is attempting to log in to the database with a password. Let's go through the steps to fix this.Step 1
Login to the
mysql
server in sudo mode as the root user and supply any required passwords.sudo mysql -u root -p
Step 2
Now run the following
ALTER USER
command, replacing root with your database user and password if your password.ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
Now run:
FLUSH PRIVILEGES;
Now exit the MySQL server:
exit;
-
March 04, 2016
In this post I will show how you can add banner ads to your Ionic apps. I will be doing this on a new app but you can do it to your existing app as well. I have also written a post on adding banner ads to Ionic 2 apps, so if you are looking for Ionic 2 apps You can check that post out as well.
Step 1)
We will first start by creating a new Ionic project by issuing the following command in the command prompt
-
February 26, 2016
The error you have received is from NPM (since the Cordova CLI is installed via NPM). This is a tricky issue where using NPM with
sudo
, and then not usingsudo
will result in weird permission issues.Solution:
sudo chown -R $USER /usr/local/
-
February 26, 2016
FAILURE: Build failed with an exception.
* What went wrong:
Execution failed for task ':CordovaLib:processDebugResources'.
> com.android.ide.common.process.ProcessException: org.gradle.process.internal.ExecException: Process 'command '/home/arulmanickam/adt-bundle-linux-x86-20131030/sdk/build-tools/23.0.2/aapt'' finished with non-zero exit value 127Solution :
For me it was that I forgot to install the 32bit dependencies:
sudo apt-get install -y lib32gcc1 libc6-i386 lib32z1 lib32stdc++6
sudo apt-get install -y lib32ncurses5 lib32gomp1 lib32z1-dev lib32bz2-dev
-
February 26, 2016
i have this error when i am trying to build
[Error: Failed to find 'ANDROID_HOME' environment variable. Try setting setting it manually.
Failed to find 'android' command in your 'PATH'. Try update your 'PATH' to include path to valid SDK directory.]Solution
You have permission errors. My guess is that you tried to run the script as root rather than sudo. When running the script you have to run it as your user account using sudo.
change owner permission all files & folder to your current login user .
- Your android sdk
- Your ionic or cordova project files
dont run as admin or run using sudo
-
February 15, 2016
I'm using PHP's built-in DOMXPath() class to do some simple web-scrapping. However, it works on my 4.2 site, but not my 5.1 (both are on same installation of PHP).
Here's the error:
$list1 =newDOMXPath();
In Laravel 5.1 you must prefix the class name with the global namespace prefix '\'.
$list1 =new \DOMXPath();
-
February 15, 2016
I'm using PHP's built-in DOMDocument() class to do some simple web-scrapping. However, it works on my 4.2 site, but not my 5.1 (both are on same installation of PHP).
Here's the error:
$list1 =new DOMDocument();
In Laravel 5.1 you must prefix the class name with the global namespace prefix '\'.
$list1 =new \DOMDocument();
-
September 15, 2015
This script quickly adds a Magento Admin user directly into the database. It is possible to run this script from the command line or by copying and pasting into phpMyAdmin. Just make sure to edit the following fields with your personalized data and import. Most of these fields are trivial, I’m just listing them so you don’t miss anything.
- Set the salt portion of your password. You’ll rarely need to change this. If you do, just use two lower case letters of your choice.
- Set your password. At least 8 characters in length and at least one digit.
- Firstname: Enter admin’s first name.
- Lastname: Enter admin’s last name.
- Enter email of admin user.
- Enter username where ‘myuser’ is set. Notice ‘myuser’ shows up in two places.
- Enter Firstname again. This is more symbolic to label the rule.
-
September 05, 2015
Introduction:
Few days ago I received a comment from one of the reader of my blog to show an example on CRUD (Create, Read, Update and Delete) with the database. So in this post we will explore the use of CRUD operation using SQLite database in PhoneGap application.Description:
CRUD can be described as a process, which helps the user to add, view, search and modify the information inside the database.Here are the basic steps which demonstrates CRUD operation.
- Create or add new entries
- Read, retrieve, search or view existing entries
- Update, modify or edit existing entries
- Delete, deactivate or destroy existing entries
Before doing any operation on database let’s initialize the database first, either using HTML5 local database concept or using SQLite plugin.
Let’s add the following javascript to initilze the database.
-
August 04, 2015
Remove selected table insert content from dump file
grep -v "INSERT INTO \`big_table\`" dump.sql > dump_stripped.sql
Remove all insert content from dump file
grep -v "INSERT INTO" dump.sql > dump_stripped_insert.sql
Replace dump.sql with your dump file name