Fedora :: ERROR 1064 (42000): You Have An Error In Your SQL Syntax; Check The Manual That Corresponds To Your MySQL

Jul 20, 2010

i ,musing mysql5 at fedora12 i have just installed it but i ,m using mysqladmin -p root password mypassword it says ERROR 1064 (42000): 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 'mysqladmin -uroot password 123456' at line 1

View 10 Replies


ADVERTISEMENT

Networking :: 1064 ERROR In MYSQL

Jan 3, 2011

While trying to provide schema to a database in mysql, I am getting this error: ERROR 1064 (42000) at line 15: 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 'FUNCTION 'upd_radgroups()' RETURNS trigger AS'.I am not getting that where the problem is. ANd below is the script which i want to use to provide schema to my database in my Centos system:-

[code]...

View 1 Replies View Related

OpenSUSE Network :: ERROR 1044 (42000): Access Denied For User ''@'localhost' To Database 'mysql'

Nov 9, 2010

I think I screwed up my Administrative username in mysql.

mysql -u root mysql
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'

Can I just copy all the files in /var/lib/mysql >>reinstall MySQL >> copy all the old folders into the new /var/lib/mysql ( while MySql is off)

View 9 Replies View Related

General :: Mysql Query With Unix Timestamp Error "check The Syntax Near The Between"

Jun 28, 2010

Quote: select * from s_transaction Where between UNIX_TIMESTAMP('2010-06-28 15:40:00') and UNIX_TIMESTAMP('2010-06-28 16:00:00') and user_id = '15545941';

Is this the syntax correct to retrieve a particular user transaction between given time period? because "its return error check the syntax near the between"

View 3 Replies View Related

General :: MySQL Boot Syntax Error?

May 23, 2011

Mental note: ignore start-up process scroll.

Okay, now MySQL is just being (even more) difficult. Prior to boot's starting MySQL, I notice the line

Code:
/etc/rc2.d/S19mysql: line 132: syntax error near unexpected token ')'
Near?? Line 132 consists of

Code:
'stop')

Which is proper, and identical to all the other /etc/rc#.d/S19mysql scripts that don't result in errors. C'mon...!

View 9 Replies View Related

Programming :: Check If A Process Is Running - Syntax Error Near Unexpected Token `else'

Feb 10, 2011

I have an ubuntu 10.10 server and want to run a script on it to check if a process is running. If it is not running, it will start the process and also write into a log file.

When running the script i get the following error message:

syntax error near unexpected token `else'

Here is my script.

View 7 Replies View Related

Fedora Servers :: Mysql 5.1.41-2 SSL Connection Error ERROR 2026 - HY000

Jan 3, 2010

I am facing some strange problem of mysql replication with ssl, my replications which working fine from more than 6 months currently stopped working after i upgrade mysql in to newver version mysql-5.1.41-2, i create new ssl self singed certs but still no sucess, when client try to connect the master using ssl its gives error SSL connection error ERROR 2026 (HY000), with out ssl its working f9.

Platform --> Fedora-11 + mysql-5.1.41-2 (both master/client)

I can seeking the problem on net, and i found the below bugzilla url related to that.

[url]

I read it but not get , either new version support x509 ssl certs or not or either new version support ssl replication or not, here below my server configuration for ssl serts

And for client

Both server and clients certs are signed with same ca but still its currently not working after the mysql upgrade first 5.1.41 and then 5.1.41-2

Either as above bugzilla url, currently mysql support ssl replication or not, or either some need to do special for working with ssl. or i wait for newver version of mysql to fix if its bug or not.

View 2 Replies View Related

Ubuntu :: Error: Syntax Error On Line 20 Of /etc/apache2/sites-enabled/portal

Feb 1, 2010

I am trying a release of Ubuntu has have run into a problem that does not make much sense. I am receiving the following error: Syntax error on line 20 of /etc/apache2/sites-enabled/portal: Invalid command 'ProxyHTMLEnable', perhaps misspelled or defined by a module not included in the server configuration
fail! I believe the modules required for this is apt-get install libapache2-mod-proxy-html and it shows under the available modules and it was enabled with a2enmod proxy-html.

The line from the config is ProxyHTMLEnable On. The release is the latest download with updates from, 32bit.

View 4 Replies View Related

Ubuntu :: Create New Directory But Keep Getting Same Error - Bash: Syntax Error Near Unexpected Token `newline'

Jan 13, 2010

I'm trying to create a new directory using the mkdir command.

Code:

home@ubuntu:~$ mkdir <aicoursework>
bash: syntax error near unexpected token `newline'

that's the error that i keep getting, what am i doing wrong?

View 5 Replies View Related

Ubuntu :: ERROR --bash: Syntax Error Near Unexpected Token 2

Feb 4, 2010

The following problem occurs to me, I'm creating a distribution (as a class project) for my school (I'm studying telecommunications and computer systems). I am following, in order to create the distribution, the manual that you can find on this page: [URL] But when I get to write:

[Code]...

View 3 Replies View Related

General :: Bash Error - Syntax Error Near Unexpected Token `{

Mar 4, 2010

I am new to shell scripting, bash specifically.

I am trying to run the following script:

Code:

When trying to execute I always get this error:

Code:

In case you need to know the permissions. Here is it:

Code:

I run the script using the following command:

Code:

View 1 Replies View Related

Programming :: Parse Error: Syntax Error, Unexpected '@' In Php Code

Jun 14, 2011

Parse error: syntax error, unexpected '@' in C:xampphtdocsminippromail.php on line 8 .......its not recognizing the '@' symbol. heres the code im working with

<?php $receiver = myfriend@ourmail.co.in; $subject = wish; $content = Hi! My dear friend how are you.; $sender = myself@ ourmail.co.in ; $headers = From: $sender; mail($receiver,$subject, $content,$headers); echo Mail has been sent successfully.; ?>

View 1 Replies View Related

General :: Error:syntax Error GRUB Or Similar

Feb 5, 2011

My brother has Tri boot Ubuntu ,7 and Vista ..GRUB2 is the bootloader..The problem : At boot after the Lenovo splash disappears , there appears some 4 to 5 lines of error , error:syntax error GRUB or similar..This is visible only for a fraction of a second before the GRUB2 menu pops up...

The OS es load properly on selection in the menu so no loss of functionality One another problem is there is no OS highlighted by default and the timeout message "Automatic Boot in 10 Secs" does not appear Reinstalling GRUB does not solve the issue

View 1 Replies View Related

Fedora :: MYSQL Error 2002 (HY000): Can't Connect To Local MySQL Server Through Socket?

Feb 22, 2011

I've been attempting to set up a LAMP for local web development, which meant installing mysql-server. But now have a problem when trying to run mysql, I get:-

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

When trying to downgrade mysql-server I saw that there are dependency problems between the various modules (but can't recall which). But whichever route I truied the results are always the same.

Thought about trying XAMPP but I note that even has it's problems, is there any way I can get a lamp set up on FC14, or must I give it up as a bad job.

Howver, just been trying to again to fix the problems with downgrading mysql and get:-

Error: Package: mysql-server-5.1.55-1.fc14.i686 (@updates)
Requires: mysql(x86-32) = 5.1.55-1.fc14
Removing: mysql-5.1.55-1.fc14.i686 (@updates)
mysql(x86-32) = 5.1.55-1.fc14

View 7 Replies View Related

Fedora :: Mysql Error When Type Mysql Into The Command Line?

Jan 16, 2011

I have mysql downloaded and when I type mysql into the command line I get this:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

View 6 Replies View Related

Ubuntu :: Error "There Was An Error Mounting /var/run Press S To Skip M For Manual Recovery"

Jun 14, 2011

not solved the correct way, reloaded using the backup i had the foresight to make i separated / into 3 partitions (/, /tmp, and /var) and after a lot of work (and hair pulling) i can now boot and login but i am getting these 2 errors during bootup

There was an error mounting /var/run Press S to skip M for manual recovery
There was an error mounting /var/lock Press S to skip M for manual recovery

[Code]....

View 3 Replies View Related

Fedora Servers :: Changing Docroot Apache - Syntax Error

Apr 13, 2010

When I want to change my docroot in /home/Vincent/www or /home/Vincent/www/ it gaves me an.
:Syntax error on line 278 of /etc/httpd/conf/httpd.conf:
DocumentRoot must be a directory

I googled it already and they sad that you have to type in:
chcon -R -h -t httpd_sys_content_t /home/Vincent/www << doesn't work so I tried also chcon -R -h -t httpd_sys_content_t /home/Vincent/www/ But nothing seems to work?

View 1 Replies View Related

General :: SUSE 10 Syslog-ng Syntax - Bash: Syntax Error Near Unexpected Token "("

Apr 20, 2011

I am a Novell (now defunct) CNE tring to learn Linux and am having a lot of trouble finding out where the WB 6-6 is wrong in the syntax for adding local4... the the syslog-ng config file. In the instructions there are discrepancies between commas and simi-comma, they are both in the statements in no particular order. there is no pattern to them. Here is what the book shows:

filter f_local4debug { level(debug) and facility(local4); };

When I try to input this in the Gnome terminal window to try and find out where it goes wrong I get the following: -bash: syntax error near unexpected token "(" If I can get the correct syntax I belive I can use the info to get past the rest of this portion of the lesson. I am desperate to learn Linux as the only jobs out there for a Novell CNE are migrations to MS, which really sucks, since MS really really sucks.

View 1 Replies View Related

Fedora :: Getting Error Message - Can't Hit On Secret Mount Syntax - Make At Least To 1400x1050?

Nov 26, 2010

I am not ready to upgrade my Fedora 13 to 14 yet, but I wanted to test some things in 14. So, using the live CD, I installed Fedora 14 under Virtualbox. But some things are not working and the Virtualbox Help files aren't helping. I have added my Fedora 13 /home/jjj/ folder as a shared folder with the name Home_jjj. The instructions say that in Fedora 14 I must mount it with "mount -t vboxsf share mount_point." So (as root in Fedora 14). I used the command "mount -t ext3 vboxsf Home_jjj /media" but I got an error message. I tried varying the command different ways, but haven't hit on the secret mount syntax. I would really just like to add it to Fedora 14's fstab file to make it auto-mount. I have an external monitor, which Fedora 13 sees, but Fedora 14 cannot see it. The main display for Fedora 13 is 1680x1050. Fedora 14 installed itself with 1024x768 as the max. I tried changing it with xrandr -s, but the only resolutions xrandr will take are 1024x788, 800x600 and 640x480. How can I make it at least, say, 1400x1050?

View 6 Replies View Related

OpenSUSE Network :: ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/mysql/mysql.sock

Jun 7, 2011

I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:

Code:
the-matrix:~ # mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or
Code:
the-matrix:~ # rcmysql start
Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds
chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory

[Code]...

View 6 Replies View Related

General :: Error While Starting Apache2 / Syntax Error On Line 113 Of /etc/apache2/httpd.conf?

Nov 19, 2010

I have suse10 64bit and I was setting up SVN server on it. After all required setup while reloading apache2,its giving the error:

Code:

httpd2-prefork: Syntax error on line 113 of /etc/apache2/httpd.conf: Syntax error on line 31 of /etc/apache2/sysconfig.d/loadmodule.conf: Cannot load /usr/lib64/apache2/mod_dav_svn.so into server: /usr/lib64/libsvn_subr-1.so.0: undefined symbol: apr_memcache_add_server

View 6 Replies View Related

Server :: Script Error: "syntax Error Near Unexpected Token Then"

Jun 9, 2011

I'm trying to get this script working, it's supposed to give me options of typing B to backup a folder, typing R to restore the backup, and typing E to exit.

[Code]....

When I attempt to run the script, I get my echos prompting me to type B, R or E and press enter. When I type B and press Enter, I get this:

Code: line 18: syntax error near unexpected token 'then' line 18: 'then'

View 14 Replies View Related

OpenSUSE :: Updated 10.3 To 11.4, Mysql Error Failed To Alter Database Error: 1102?

May 17, 2011

I upgraded a system from 10.3 to 11.4 and I get the following error when trying to run mysql:

Will update MySQL now, if you encounter any problems, please read following file:
/usr/share/doc/packages/mysql-community-server/README.SuSE
Log files inconsistency, please merge following files manually:
/var/lib/mysql/mysqld.log
/var/log/mysqld.log

How can I correct this? Mysql will not start so I can not run any of the utilities.

View 2 Replies View Related

Ubuntu :: GRUB "error: Syntax Error" On Boot?

Nov 3, 2010

Whenever I boot my laptop, I get the following three lines:Code:error: syntax error.error:Incorrect command.error: syntax error.Right after I see the error messages for a couple seconds, the boot screen shows up and the rest of the boot progresses as normal. I'm on a Wubi 10.10 ubuntu install and I'm pretty sure this error has something to do with the GRUB_TIMEOUT line on 'etc/default/grub' file.I was experiencing some weird glitches with the boot splash screen (it was in the wrong resolution and would not display some times) so I edited that file to make it work. Here is the file:

Code:
# If you change this file, run 'update-grub' afterwards to update
# /boot/grub/grub.cfg.

[code]....

View 9 Replies View Related

General :: Error: Syntax Error Before "pid_t" - In Unistd.h ?

Apr 2, 2010

error: syntax error before "pid_t" - in unistd.h ?

View 3 Replies View Related

Software :: Rote.h:121: Error: Syntax Error Before "pid_t"

Apr 2, 2010

I'm trying to compile some code off sourceforge, and getIn file included from rote.c:22:

rote.h:121: error: syntax error before "pid_t"
rote.h:121: warning: no semicolon at end of struct or union

[code]....

View 2 Replies View Related

Programming :: Error - "syntax Error Near Unexpected Token Done"

Jul 23, 2011

I am a newbie in unix shell script programming . After I have tried to execute this code , I found the problem said that "syntax error near unexpected token done" . I don't know that where is the mistake in my code . Could anyone help me out this problem ?, PS* : I executed it in Redhat Enterprise Linux 4 and this is my code :

#!/bin/ksh
# Purge Script
# Input:
# 1. path (absolute path)
# 2. filename (does not apply to empty folder name)
# 3. retention policy (in day)

[Code]...

View 6 Replies View Related

Fedora :: Check Error On HDD

Sep 1, 2009

How do I check disk error under Linux just like scandisk or chkdisk

View 2 Replies View Related

Ubuntu :: VNC With SSH / Error In Manual?

Jan 11, 2011

how to use create a ssh tunnel for vnc. I have fought with this explanation for some days, and hopeless trial and error finally worked. Here is the explanationEach time you want to connect to your PC, follow these steps:

Find your PC's public name or IP address. Unless your PC has been assigned a memorable name, the easiest way to do this is to go to whatismyip.com from your PC. You can assign your PC a name by getting one from a dynamic DNS provider.Start the SSH client on the computer you'll log in from.Tell the SSH client to use local port-forwarding to connect port 5,900 on your desktop to port 5,900 on localhost.Via the SSH client, run the command x11vnc -safer -localhost -nopw -once -display :0 on the computer whose desktop you will view.where someone suggests to create a local port forward. The person who asks in this thread, has apparently read the same manual as I. The suggestion works, but I am not entirely certain that I have created a secure connection by "locally" forwarding port 5900 on the phone to localhost:5900. Can someone confirm this?Am I correct in assuming that the line "Tell the SSH client to use local port-forwarding to connect port 5,900 on your desktop to port 5,900 on localhost." in the explanation should read "on your remote laptop"?

View 1 Replies View Related

Fedora :: TRANSACTION CHECK ERROR When Updating

Mar 18, 2010

yum clean all

yum update gives this error:

Code:

It has been working until this. I shouldn't think that I need both the 586 and the 64 versions, but it won't let me get rid of the 586 version. Trying to do that results in:

Code:

Is trying to remove kdelibs-6:4.4.1-1.fc11.i586 what I should be doing? Or am I being dense?

View 14 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved