This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm whether you accept or reject these cookies being set.

A cookie will be stored in your browser regardless of choice to prevent you being asked this question again. You will be able to change your cookie settings at any time using the link in the footer.

MYSQL Stop Working
#1
MYSQL Stop Working
Hello Guys,

I'm having the next problem is that mysql randomly shut down.

These are two logs error, I hope that someone could give me a hand.

First Error

Second Error

Thanks in advance  Heart
Reply
Thanks given by:
#2
RE: MYSQL Stop Working
Hi,

I see:

RROR: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1
170519 0:01:37 [ERROR] Aborting

Did you upgrade mysql? Seem not or modify mysql.ini ?

M B
No support using PM (Auto adding to IGNORE list!), use the forum. 
How to ask
Freelance AWS Certified Architect & SysOps// DevOps

10$ free to start your VPS
Reply
Thanks given by:
#3
RE: MYSQL Stop Working
(05-24-2017, 06:35 PM)Me.B Wrote: Hi,

I see:

RROR: 1064  You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1
170519  0:01:37 [ERROR] Aborting

Did you upgrade mysql? Seem not or modify mysql.ini ?

M B

No, I didn't. I was running the server in 512 mb ram, upgraded to 1 GB and no problem so far!

When I created my first user, I was kicked so when I go to user it say that there are 3 user but I only can see two user and I don't know how to eliminate the first one

Thanks
Reply
Thanks given by:


Possibly Related Threads…
Thread Author Replies Views Last Post
MySQL Database user prefix MosleyCale 1 4 ,936 10-17-2020, 09:11 PM
Last Post: Ron-e
Senator crash problem with mysql provokas 3 9 ,678 08-20-2020, 04:11 AM
Last Post: Your Creator
MySQL remote access... pixelbat 11 38 ,070 05-02-2020, 07:40 PM
Last Post: upendra.sahu1990@gmail.com

Forum Jump:


Users browsing this thread: 1 Guest(s)