MySQL
How To Use MySql On Mac
MySql is a very popular relational SQL database server software. It is widely used in huge of websites as a database server. This article will tell you how to install the MySql database server and GUI client tool on macOS to make MySql database management easy. It will also tell you how to start, stop, …
How To Connect To MySQL Server After Install XAMPP On Mac OS
XAMPP is a software package that is a bundle of apache, MySQL, and FTP packages. You always need to use it when you develop a PHP + MySQL application. It is easy to use on Windows, but when I use it on Mac OS, I meet some errors, this article will tell you how to …
How To Connect To MySQL Server After Install XAMPP On Mac OS Read More »
Python Connect To MySQL Database With MySQL Connector & PyMySQL Example
When you want to connect to the MySQL database in Python code, you can use both the mysql-connector-python MySQL driver and PyMySQL. The mysql-connector-python MySQL driver is a MySQL server built-in driver and the PyMySQL is a third-party library. All the two MySQL python libraries provide classes for you to get MySQL database connection, execute insert, delete, …
Python Connect To MySQL Database With MySQL Connector & PyMySQL Example Read More »
Pymysql Cursor.fetchall() / Fetchone() Returns None
PyMySQL is a python library that can connect to the MySQL database. But these days when I execute the select SQL command through PyMySQL, I found the execution does not return any records from the database table, but the data really exists in the database table. And when I run the SQL command in the …
Pymysql Cursor.fetchall() / Fetchone() Returns None Read More »
How To Resolve Access Denied For User ‘root’@’localhost’ (using Password: Yes) When Connect MySQL Database
When I connect MySQL databases in source code, such as Java code or Python code. I encounter an error which I do not meet when I use MySQL client tool software to connect it. The error message is Access Denied For User ‘root’@’localhost’ (using Password: Yes). To resolve this issue is not hard, this example …
Spring Boot CRUD Example With MySQL
This example will tell you how to use spring boot data JPA to implement insert, update, delete and select database table operation on MySQL database table. With spring boot data JPA the database table operation command has been wrapped to a method, you just need to create a java interface that extends basic spring boot …
How To Fix MySQL JDBC 08001 Database Connection Error
When you use MySQL JDBC driver to connect to MySQL database server. You may encounter bellow error messages. try { Connection connection = DriverManager.getConnection(“jdbc:mysql://localhost:3306/dev2qa?useSSL=false”,”test”,”666888″); } catch (SQLException ex) { ex.printStackTrace(); System.out.println(“SQL State : ” + ex.getSQLState()); } Below are the error messages. INFO: Pre-instantiating singletons in org.s[email protected]36d64342: defining beans [org.springframework.beans.factory.config.PropertyPlaceholderConfigurer#0,dataSource,userAccountDao]; root of factory hierarchy com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: …
How To Fix MySQL JDBC 08001 Database Connection Error Read More »
How To Load JDBC Configuration From Properties File Example
If you need to switch between different databases using JDBC, you can store different database JDBC connection-related information in a properties file. And then you can load the JDBC properties data in java source code to use them. This example will show you how to do it, and how you can utilize its benefits.
