Connection Strings for SQL Serverhttps://joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

05 January 2011 Class Library Usage: Devart.Data.MySql.MySqlConnection Manufacturer: Devart Standard User ID=root;Password=myPassword;Host=localhost;Port=3306;Database=myDataBase; Direct=true;Protocol=TCP;Compress=false;Pooling=true;Min Pool Size=0;Max Pool...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server
• Language: *

Migrate MediaWiki to another serverhttps://joellipman.com/articles/cms/mediawiki/migrate-mediawiki-to-another-server.html

23 September 2009 that both mysql versions should be same. grant create, select, insert, update, delete, lock tables on wikidb.* to wiki@localhost identified by 'YourPassword' ; MediaWiki Upgrade copy all the new files to wiki folder and then run php update.php from...

• Type: Article
• Author: Joel Lipman
• Category: MediaWiki
• Language: en-GB

Country Lookup by IP address CSVhttps://joellipman.com/articles/database/mysql/country-lookup-by-ip-address.html

17 March 2013 the drop statement if running for the second time. Modify the PHP file to use database login credentials, $db_host = "localhost"; // Database host name $db_user = "my_database_user"; // User for database authentication $db_pass = "my_database_password";...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: *

Zoho Creator: Create a Widget which uses JavaScripthttps://joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 “http” [Optional Step] This is an added note/step if you get the following error when trying to access your app on your localhost: “127.0.0.1 normally uses encryption to protect your information. When Google Chrome tried to connect to 127.0.0.1 this...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

MySQL Commands to display all columnshttps://joellipman.com/articles/database/mysql/mysql-commands-to-display-all-columns.html

28 October 2010 keywords from. The following is a MYSQL query that displays the structure of all the columns in all the databases of the localhost: SELECT * FROM information_schema.COLUMNS ORDER BY TABLE_NAME, COLUMN_NAME The following is a MYSQL query that finds all...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB