Tag Info

New answers tagged

1

The folder C:\Program Files\MySQL\MySQL Server 5.6 is the correct location for my.ini. There are two possible reasons 1400 shows up as table_definition_cache. REASON #1 You did not restart mysql. Login to Windows DOS command line as Administrator and run C:\> net stop mysql C:\> net start mysql Value should be in place afterwards. REASON #2 ...


1

You will have to find the my.ini, look for init_connect, and change it, remove it, or comment it out. Then, run net stop mysql net start mysql If the values keep getting reset anyway, you have to do the following: Create a file called C:\mysql_init.sql the the contents SET GLOBAL init_connect=''; Go back to my.ini and add this line ...


0

As stated in the documentation you do not pass the UID and PWD to utilize Windows Authentication. You can see an example here. From remarks within documentation link: If values for the UID and PWD keys are not specified in the optional $connectionInfo parameter, the connection will be attempted using Windows Authentication. For more information about ...


1

If you are using Windows, you need not worry about named pipes at all. Why ? Years ago, MySQL for Windows had distributed three(3) different executables: mysqld.exe mysqld-nt.exe mysqld-max-nt.exe The two executeables mysqld-nt.exe and mysqld-max-nt.exe used the named pipes protocol. This is briefly mentioned in Chapter 23 Section 23.2 Page 353 ...


1

This is something you set up when starting the mysqld daemon (or service on Windows). You should (don't have Windows running) be able to see your startup options using the Task Manager (or failing that, use Process Explorer from here).


1

I think your problem boils down to a misalignment of grants. When you run this query SELECT COUNT(1) column_count FROM information_schema.columns WHERE table_schema='mysql' AND table_name='user'; You should the following number If you get 43, MySQL 5.6 If you get 42, MySQL 5.5 If you get 39, MySQL 5.1 If you get 37, MySQL 5.0 It simply means you ...


1

You literally do not need a third party tool. STEP 01 Find out the path to the data by running mysql> SHOW GLOBAL VARIABLES LIKE 'datadir'; For this example, let's suppose it is C:\Program Files\MySQL\MySQL 5.6\data STEP 02 Pick a destination folder to copy the data directory For this example, let's pick D:\MySQLBackup STEP 03 Create batch file ...


1

The options file in MySQL is a human-readable text file, typically called my.cnf on Unix and my.ini on Windows. This single file contains configuration entries for all things MySQL, including the server, and the client library, and the various other official client utilities. The screen you're referring to is a glorified configuration file editor for that ...



Top 50 recent answers are included