473,386 Members | 1,969 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

How To Increase Max_Allowed_Packet In Mysql In Windows 8 I Tried Editing .Ini File Bu

1
I tried editing .ini file, it prompts access in denied. And if i try to chnage using command prompt that also it does no allow me to do so.I cannot even use "Show Max_allowed_packets". It says show is not recognized as internal and external command.

Expand|Select|Wrap|Line Numbers
  1. # For advice on how to change settings please see
  2. # http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
  3. # *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
  4. # *** default location during install, and will be replaced if you
  5. # *** upgrade to a newer version of MySQL.
  6.  
  7. [mysqld]
  8.  
  9. # Remove leading # and set to the amount of RAM for the most important data
  10. # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
  11. # innodb_buffer_pool_size = 128M
  12.  
  13. # Remove leading # to turn on a very important data integrity option: logging
  14. # changes to the binary log between backups.
  15. # log_bin
  16.  
  17. # These are commonly set, remove the # and set as required.
  18. # basedir = .....
  19. # datadir = .....
  20. # port = .....
  21. # server_id = .....
  22.  
  23.  
  24. # Remove leading # to set options mainly useful for reporting servers.
  25. # The server defaults are faster for transactions and fast SELECTs.
  26. # Adjust sizes as needed, experiment to find the optimal values.
  27. # join_buffer_size = 128M
  28. # sort_buffer_size = 2M
  29. # read_rnd_buffer_size = 2M 
  30.  
  31. sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

this is my .ini file
Aug 20 '15 #1
1 1799
Luuk
1,047 Expert 1GB
find the file 'Notepad.exe' in Windows Explorer, right-click on it, and choose 'Run as administrator'.

From that notepad, open your ini-file.
Sep 12 '15 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: francescomoi | last post by:
Hi. I'm trying to build 'MySQL-python-1.2.0' on my Linux FC2: ---------------------------------- # export PATH=$PATH:/usr/local/mysql/bin/ # export mysqlclient=mysqlclient_r # python setup.py...
2
by: Steve | last post by:
Hi. I've got an exported database from an external system. It's in the format of MYI, MYD and frm extension files. However, one table in this database has book.frm, book.MYD, book.MYI _AND_...
3
by: Daedalus.OS | last post by:
Hi, I've been asked to transfert a database from a webhoster to another. I think the database is on a windows box but I'm not 100% shure. The webhoster says it provides combined hosting on...
1
by: Buddy | last post by:
Hello, I need to know how can I generate a .resx file from code for different language culture. Basically the .resx file is in binary, is there anyway that I can generate a text file contains...
1
by: Carlos Pena | last post by:
I have MySQL server running fine on Linux Server. I need to connect Windows workstations to the MySQL server. I installed MySQL ODBC 3.51.14 driver. When i try to connect the ODBC allways returns...
1
by: ponvijaya | last post by:
I want to take back up of records in My MySql Database I want to convert the records into csv file and store in a location. If needed I want to import it to the same database.. I need to...
5
by: BillE | last post by:
I am using VB.NET, VS 2005 Add a windows form and in design view: Add a Radiobutton to the windows form Set AutoSize = True for the radiobutton Set the MaximumSize width to 90 for the...
14
by: Peter | last post by:
..NET 3.5 I have a Windows Service application and it does remoting, but when a client incounters an error the client get the following error message "Server encountered an internal error....
0
by: raana syeda | last post by:
Please tell me how to get the Windows Xp program file path using java as I am using java1.6.0
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.