Main menu

Skip to content
  • eBooks in PDF
  • Photography
  • Recommending
  • Tutorials
  • Who’s this JC?

JustChecking's Weblog On All

Life, science, programming, and all… convincing and meaningless.

RSS

Tag Archives: mySQL

MySQL Error 1045 – Access Denied

Posted by JustChecking on December 23, 2013

I’ve had quite a headache couple of days ago with the Access Denied 1045 error with remote access to MySQL, so I’ve created a step-by-step guide to debugging this:

Error 1045 Access Denied Troubleshooting Guide

Leave a comment Posted in Computers, SQL, Troubleshooting Tagged access denied, error, error 1045, guide, mySQL

Create User in MySQL if It Does Not Exist

Posted by JustChecking on July 31, 2011

MySQL does not support create user if not exists syntax as it does with create table and create procedure. This is pretty weird, as it just boils down to checking whether single row exists in the `mysql`.`user` table.

Continue reading →

3 Comments Posted in Computers, Programming, Security, SQL, Tips and Tricks Tagged create user, grant, if not exists, mySQL

How to enable mySQL in PHP5 on Windows

Posted by JustChecking on February 9, 2008

Apache+mySQL+PHP is for sure among the best and the most popular combinations of web-development products; but sometimes a proper setup is a tricky bit.

Continue reading →

14 Comments Posted in Computers, PHP, Programming, Tips and Tricks, Troubleshooting, Windows Tagged Apache, mySQL, PHP, PHP5, Web Development, Windows, XAMPP

Buy me a coffee

All proceedings go to server and coffee time.

Buy me a coffee...

Pages

  • eBooks in PDF
  • Photography
  • Recommending
  • Tutorials
  • Who’s this JC?

Blogroll

  • A Brief Message
  • A Quantum Diaries Survivor
  • all the standard catastrophes
  • Charm
  • Fractal Folds
  • GoDrex.com
  • I (camera) Food
  • Insane Security
  • Jim McGill photo
  • Symmetry factor
  • Twisted One 151’s Weblog

Linux Stuff

  • Top 100 NetSec Tools
  • Ubuntu Geek
  • Ubuntu Linux
  • Ubuntu Pocket Guide

My Faves

  • APOD
  • Chaos Engine
  • Doris music presentation
  • Get Your War On
  • happygirlforever@deviantart
  • John Baez’s Stuff
  • RetouchPRO
  • SubGenius
  • Truth with Doris

My Stuff

  • genmake Makefile Generator
  • JustChecking's Paskvil
  • My LinkedIn
  • PaskvilWiki

Programming etc.

  • CodeGuru.com Forums
  • Ethical Hacker
  • The Code Project
  • Top 100 NetSec Tools

Categories

  • Books (12)
  • Computers (82)
    • Linux (43)
    • Photoshop (4)
    • Programming (56)
      • C/C++ (28)
      • Lisp (1)
      • PHP (8)
      • SQL (4)
    • Security (8)
    • Virtualization (5)
    • Windows (28)
  • Humor (7)
  • Illustrations (6)
  • Music (3)
  • Nature (14)
  • Panorama (3)
  • Philosophy (2)
  • Photography (17)
  • Rants (7)
  • Science (3)
    • Physics (3)
  • Tips and Tricks (63)
  • Troubleshooting (26)
  • Tutorials (31)
  • Uncategorized (3)

Calendar

January 2021
M T W T F S S
 123
45678910
11121314151617
18192021222324
25262728293031
« Mar    

Archives

  • March 2014
  • December 2013
  • November 2013
  • October 2013
  • March 2013
  • January 2013
  • November 2012
  • July 2012
  • April 2012
  • March 2012
  • January 2012
  • November 2011
  • August 2011
  • July 2011
  • June 2011
  • May 2011
  • March 2011
  • December 2010
  • August 2010
  • July 2010
  • April 2010
  • February 2010
  • January 2010
  • December 2009
  • June 2009
  • February 2009
  • January 2009
  • December 2008
  • November 2008
  • September 2008
  • August 2008
  • July 2008
  • June 2008
  • May 2008
  • April 2008
  • March 2008
  • February 2008
  • January 2008

Meta

  • Register
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.com

Create a free website or blog at WordPress.com.

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy