After creating a new user you need to update his privileges to grant creation of procedures, functions and so on. Here is a SQL for this.
UPDATE user SET
Select_priv="Y", Insert_priv="Y", Update_priv="Y", Delete_priv="Y", Create_priv="Y", Drop_priv="Y", Reload_priv="Y", Process_priv="Y", File_priv="Y", References_priv="Y", Index_priv="Y", Alter_priv="Y", Super_priv="Y", Create_tmp_table_priv="Y", Lock_tables_priv="Y", Execute_priv="Y", Create_view_priv="Y", Show_view_priv="Y", Create_routine_priv="Y", Alter_routine_priv="Y", Event_priv="Y", Trigger_priv="Y"
WHERE user = "xxxxx";
FLUSH PRIVILEGES;
Wednesday, November 27, 2013
MySQL privileges update for creating procedures, functions, etc.
Posted by Unknown at 12:20 PM 0 comments
Labels: MySQL
Monday, March 25, 2013
jQuery executes error function even on success (200) status
Just lost a couple of hours with this problems.
jQuery was executing an error function regardless the jqXHR status. A little bit about setup:
node.js + Express + Backbone + backbone.paginator + Underscore
After upgrading to Express 3.0 an application that was working without any problems stoped to work. Problem - jQuery was always executing an error function for all ajax requests. After checking the code, googling, reading, debugging, taking a lunch, debugging again and again I saw that I was using res.json() and not res.jsonp() (added in Express 3.x). Change of one line and everything is working back again.
So - if your node.js + express 3.x returns jsonp, please, use res.jsonp() instead of res.json()
Posted by Unknown at 9:16 PM 0 comments
Labels: AJAX, backbone.js, express.js, JavaScript, jQuery, node.js, underscore.js