Monthly Archives: April 2023

Can’t connection to MySQL Python

Posted on April 29, 2023 by chanmingman

This blog article shows you one of the possible ways to resolve the error “Can’t connection to MuSQL“. One of the reasons is, you have the code below to open the MySQL database connection. in Python mydb = mysql.connector.connect(     host=”localhost”, … Continue reading →

Posted in Uncategorized | Leave a comment

The Innovator’s Guide to Zero Trust Security

Posted on April 26, 2023 by chanmingman

More than 80% of security teams are moving toward the Zero Trust framework – widely accepted as the new standard in security – but it’s about more than just the right technology. Learn how to implement a comprehensive, ongoing approach … Continue reading →

Posted in Uncategorized | Leave a comment

Python Read Data from MySQL

Posted on April 26, 2023 by chanmingman

This blog article shows you how to read the data from MySQL using Python. Firstly, Import the required modules: import mysql.connector Establish a connection to the MySQL database: mydb = mysql.connector.connect( host=”localhost”, user=”yourusername”, password=”yourpassword”, database=”world”) Create a cursor object to … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, programming | 1 Comment

Visual Studio 2022 Predict the Next Statement while Editing (IntelliCode)

Posted on April 24, 2023 by chanmingman

This short blog article is recapping one or two features that do well in Visual Studio 2022. Microsoft rarely mentions Visual Studio now a day, but Visual Studio is still a friendly tool for development. Instead of IntelliSense that we … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, CTO | Tagged | Leave a comment

A Modern Workforce Requires Integrated, Identity-Driven Security

Posted on April 24, 2023 by chanmingman

As more companies embrace remote and hybrid work, they face greater vulnerabilities and inefficiencies with employees having multiple sign-ons. The eBook A Modern Workforce Requires Integrated, Identity-Driven Security unpacks these vulnerabilities and discusses how: Managing different point solutions to improve … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, CTO, Data Platform, management, Office 365 | Tagged , | Leave a comment

ModuleNotFoundError: No module named ‘mysql.connector’; ‘mysql’ is not a package

Posted on April 23, 2023 by chanmingman

This blog article will reduce your pain on solving the error “ModuleNotFoundError: No module named ‘mysql.connector’; ‘mysql’ is not a package“. I took hours to resolve this. Fortunately, I found a link at the reference below. II follow another link … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | Leave a comment

CTO April 2023 articles and resources

Posted on April 22, 2023 by chanmingman

These are the good reads found in this month. 5 hot IT budget investments — and 2 going cold Hot: AI and VR/AR Hot: Zero trust and other security initiatives Cold: On-prem infrastructure… https://www.cio.com/article/302803/7-hot-it-budget-investments-and-4-going-cold.html Design effective AI prompts with Microsoft … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, CTO, Data Platform, management | Tagged | Leave a comment

Cannot cast DBNull.Value to type ‘System.Int32′. Please use a nullable type’

Posted on April 22, 2023 by chanmingman

This blog article shows you one of the possibilities to resolve the error “Cannot cast DBNull.Value to type ‘System.Int32’. Please use a nullable type”. In order to check whether my properties are null with int data type I tried the … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | Leave a comment

ADO.NET Read MySQL Database

Posted on April 21, 2023 by chanmingman

The blog article shows you how to read MySQL using ADO.NET. Firstly, import the required namespaces: using System.Data; using MySql.Data.MySqlClient; Establish a connection to the MySQL database: string connectionString = “server=localhost;database=world;uid=root;password=123456”; MySqlConnection connection = new MySqlConnection(connectionString); connection.Open(); Define the SQL … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Oracle, Servers | Tagged | 3 Comments

Insert statement difference between MySQL and MSSQL

Posted on April 21, 2023 by chanmingman

This blog article shows you a possible way to Export Data from MySQL then modify the SQL statement in order to import the data into MSSQL. After you use one of the MySQL tool such as HeidiSQL to Export the … Continue reading →

Posted in .Net, Cloud, Computers and Internet, Data Platform | Tagged | Leave a comment