database – Page 2 – POFTUT

Tagged: database


How To List MySQL Database Users?

MySQL database server have users to connect and use databases and tables. Users provides security for database operations. MySQL server comes with default users or in the operations a lot of users are created. In this post we will look how to list these users. Connect To Database We will connect to the MySQL database server to list user. MySQL is a tool used to manage databases, tables, users and...


How To List MySQL / MariaDB Database?

MySQL is very popular opensource database. MySQL is created by MySQL AB a Swedish company and then bought by Sun. Sun is bought by Oracle and MySQL is currently owned by Oracle. MySQL is very popular at opensource community. In this post we will look how to list databases in MySQL. Check MySQL Service Status We need to be sure that MySQL daemon is running we will check with following...


How To Create Fast Simple Database and Table With Php and Sqlite

Php is web programming language very popular among developers. Php is actually a scripting language which means there is no need to compile the code to run. So write and run is the motto of php language. Php scripts can be run on Linux systems like bash, Perl scripts too. Some administrators with development background prefers php for scripting because php offers more than bash scripting. SQlite is an other...


How To List MySQL/MariaDB Databases

I have some MySQL databases. I have no previous experience about MySQL. How can list existing databases with bash?MySQL and MariaDB are using same code base and tools. So we can use following instructions to list MariaDB too. Check Database Service First be sure MySQL/MariaDB service is running

As we can see from systemctl output the database service is working properly. Login To MySQL Interactive Shell In order to...


How To Prevent SQL Injection in Php Applications?

I have an application and I have complex requests tot the server. There are a lot of database operations. Managing them can become very hard some times. In this situation how can I prevent sql injection attacks to my application. Use Prepared Statements Prepared statements are the way to bind client-side provided values with database queries. Prepared Data Object (PDO) acts middle proxy and prevents SQL injections. PDO is supported...


How To Access MySQL Database From Java Applications?

Java is popular programming language generally used commercial and enterprise applications. MySql is popular database too which is used big service providers like Google, Facebook etc. Most of the applications generally uses data and needs to store this data in a relational database. MySQL is generally the first choice if we do not want to give money for license. In this tutorial we will look how to connect a Java...


What is The Difference Between Inner and Outer Join?

Sql is the language where a lot of data can be get with different logic. In an enterprise environment we may need to use complex SQL queries to get meaningful data. Inner is one of the logic where we join two tables with different magic. Example Tables In order to understand Inner and Outer Joins we will use following example tables with their data. We will use two tables those...


How To Use Mysql / MariaDB From Console?

Mysql is one of the most popular databases in IT world. It is open source and have rich features were paid databases provides. MariaDB is fork of the MySQL and very similar to it. We have already looked how to login and do simple steps in this post Getting Help In order to connect to a MySQL or MariaDB database server we will use mysql command. mysql command provides a...

Enjoy this blog? Please spread the word :)