ERROR 1064 (42000): You have an error in your SQL syntax;

syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Sorry, little confused right about now, eh. Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

auto_increment Question

(mysql_error()); Mark Sargent -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Is This A Redundant Info Example?

do it differently, and could you tell us why? Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Starting mysql through sudo

usually) and change the sudoers file(/etc/sudoers) to reflect that. Is there a reason why you only want manual startups of MySQL? I just added the startup script to my /etc/init.d dir as mysql, gave it execution permissions and did a chkconfig and it always runs at boot. Cheers. Mark Sargent. EDIT

Syntax Error

-tables.html I'm a Linux user, and wish to do everything via cli as opposed to phpmyadmin. Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Syntax Error

Hi All, Ah, sorry, a semicolon makes it a whole new world, eh. Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Prinitng MySQL Structure from ssh

Hi All, we have cli access to our MySQL database via ssh in the Admin GUI and were wondering how to print the complete structure of a DB. I searched the documents on MySQL homepage but couldn't find anything specific. Anyone know how to do this? Cheers. Mark Sargent. -- MySQL General

Re: Prinitng MySQL Structure from ssh

alexj wrote: try mysqldump --no-data database-name -u user-name Hi All, thanx, but get the following, mysql mysqldump --no-data osc -u admin; ERROR 1064: You have an error in your SQL syntax near 'mysqldump --no-data osc -u admin' at line 1 Cheers. Mark Sargent -- MySQL General Mailing

Re: Many Attributes Required Design Query

. Any further thoughts on this? Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Prinitng MySQL Structure from ssh

Duncan Hill wrote: mysqldump is a shell command, not a mysql command. Hi All, oops, what a blunder. lol. Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Many Attributes Required Design Query

Hi All, I have the job of creating a DB for an online clothing company. I have some experience with relational design and sql and php. I'm stumped as they have products that contain numerous attributes, and are wishing to get away, if possible, with entering separate records for each and

Re: Many Attributes Required Design Query

: object_id object_desc That is where I got to, as I've never done this kinda design before. Thrown into the deep end, I guess. May I ask for more assistance with this? Where does the quantity go? Any tutorials on this kind of design? Cheers. Mark Sargent. -- MySQL General Mailing List For list

Re: Many Attributes Required Design Query

originally stated and whether OSCommerce could be tweaked to get around that. Whilst not getting away from the initial topic, your thoughts would be greatly appreciated on using OSCommerce. Pros ad Cons. My initial responsibility is to gauge what is their best direction for this. Cheers. Mark

Grant Syntax Error.?

Hi All, trying to create a new user with the below, GRANT ALL PRIVILEGES ON *samhain* TO 'samhain'@'localhost' IDENTIFIED BY 'passwd' WITH GRANT OPTION; but, it gives a syntax error message. mysql version is 4.1.12. What is wrong with the syntax.? Cheers. Mark Sargent. -- MySQL General

Product Table Design Question

are, switches/routers/dedicated servers/firewalls etc. Should I just make a Specs table, or, specific table for each type of product.? Appreciate any thoughts on this. Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Displaying Dynamic Japanese

it in a UTF-8 set page, it is just ? marks, although static J text displays fine...any thoughts on this..? Driving me nutz. Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error Connecting To Server From Client Machine-Linux

Alvaro Cobo wrote: Have you checked if in the /etc/mysql/my.cnf the directive allow networking is uncommented?. This is a quite usual mistake. Also check the host permissions of the root user. Hope this helps. Alvaro. - Original Message - From: Mark Sargent [EMAIL PROTECTED] To: mysql

Error Connecting To Server From Client Machine-Linux

..? Is it mysql related..? Still a newb, so I'm sure it's somethiing real easy. Cheers. Mark Sargent. phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond

Re: no /tmp/mysql.sock

Hassan Schroeder wrote: Mark Sargent wrote: ... but, my real query, now, is, why the configs/my.cnf were different, Because there isn't any /etc/my.cnf created on your system by default; you are responsible for creating one if needed, using the examples in the ./support-files subdirectory

Re: mysql_install_db for linux basedir query

Mark Sargent wrote: Hi All, if this script is in scripts by default, why does it have the following code, test -z $ldata ldata=./data if test -z $basedir then basedir=. bindir=./bin execdir=./bin pkgdatadir=./support-files else bindir=$basedir/bin if test -x $basedir/libexec/mysqld

no /tmp/mysql.sock

Hi All, mysql is running, but, there seems to be no /tmp/mysql.sock file. How is this file generated..? I can't connect, keep getting errors. What about via a port..? What is the argument for that..? Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: no /tmp/mysql.sock

Simon Garner wrote: Mark Sargent wrote: Hi All, mysql is running, but, there seems to be no /tmp/mysql.sock file. How is this file generated..? I can't connect, keep getting errors. What about via a port..? What is the argument for that..? Cheers. Mark Sargent. It's probably not in /tmp any

Re: no /tmp/mysql.sock

Mark Sargent wrote: Simon Garner wrote: Mark Sargent wrote: Hi All, mysql is running, but, there seems to be no /tmp/mysql.sock file. How is this file generated..? I can't connect, keep getting errors. What about via a port..? What is the argument for that..? Cheers. Mark Sargent. It's probably

Re: no /tmp/mysql.sock

Mark Sargent wrote: Mark Sargent wrote: Simon Garner wrote: Mark Sargent wrote: Hi All, mysql is running, but, there seems to be no /tmp/mysql.sock file. How is this file generated..? I can't connect, keep getting errors. What about via a port..? What is the argument for that..? Cheers. Mark

Re: no /tmp/mysql.sock

Simon Garner wrote: On 6/05/2005 4:18 p.m., Mark Sargent wrote: Ok, I just took a punt, and changed the setting in my.cnf to reflect the config settings, to /tmp/mysql.sock, and all is well. What I don't un, is, why the default settings were like this, I certainly made no changes to either

Re: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Hassan Schroeder wrote: Mark Sargent wrote: h, that is annoying, as I did a yum remove mysql b4 installing 4.1. Shouldn't the yum remove, remove it fully..? Sorry, can't help there, don't know anything about 'yum'. [EMAIL PROTECTED] ~]# mysql -p Enter password: Welcome to the MySQL monitor

Re: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Hassan Schroeder wrote: Mark Sargent wrote: ok, I don't fully understand why, but, mysql is still installed in /usr/bin. What I've done, just for now, is renamed mysql in that dir to mysqlold. I've added /usr/local/mysql/bin to my path. I then tried the cmd mysql and also ./mysql from within

Re: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Simon Garner wrote: On 2/05/2005 5:21 p.m., Mark Sargent wrote: Hi All, I did this below, mysqlSET PASSWORD FOR 'root'@'localhost' = PASSWORD('whatafraka'); and then tried logging on, [EMAIL PROTECTED] bluefish-1.0]# mysql -h localhost -u root -pwhatafraka ERROR 1251: Client does not support

Re: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Mark Sargent wrote: Simon Garner wrote: On 2/05/2005 5:21 p.m., Mark Sargent wrote: Hi All, I did this below, mysqlSET PASSWORD FOR 'root'@'localhost' = PASSWORD('whatafraka'); and then tried logging on, [EMAIL PROTECTED] bluefish-1.0]# mysql -h localhost -u root -pwhatafraka ERROR 1251: Client

Re: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Simon Garner wrote: On 2/05/2005 6:05 p.m., Mark Sargent wrote: Hi All, master/client are the same machine. I installed via tar.gz, ver 4.1 following this page http://dev.mysql.com/doc/mysql/en/installing-binary.html for installation on FC3. Why would it say that the client doesn't support

Re: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Mark Sargent wrote: Simon Garner wrote: On 2/05/2005 6:05 p.m., Mark Sargent wrote: Hi All, master/client are the same machine. I installed via tar.gz, ver 4.1 following this page http://dev.mysql.com/doc/mysql/en/installing-binary.html for installation on FC3. Why would it say that the client

Re: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Mark Sargent wrote: Mark Sargent wrote: Simon Garner wrote: On 2/05/2005 5:21 p.m., Mark Sargent wrote: Hi All, I did this below, mysqlSET PASSWORD FOR 'root'@'localhost' = PASSWORD('whatafraka'); and then tried logging on, [EMAIL PROTECTED] bluefish-1.0]# mysql -h localhost -u root -pwhatafraka

mysql_install_db for linux basedir query

/libexec elif test -x $basedir/sbin/mysqld then execdir=$basedir/sbin else execdir=$basedir/bin fi where basedir=. as that would instruct the script to look for all dir's from within the script dir, not the mysql dir. Can anyone explain why this is so..? Cheers. Mark Sargent. -- MySQL

Re: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Hassan Schroeder wrote: Mark Sargent wrote: [EMAIL PROTECTED] bluefish-1.0]# mysql -h localhost -u root -pwhatafraka ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client What is this..? Why is it asking me to upgrade the client

ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

MySQL client What is this..? Why is it asking me to upgrade the client.? Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Can't Access Via Webmin or PhpMyAdmin.

Mark Sargent wrote: Hi All, I can start mysql with the following cmd, /etc/rc.d/init.d/mysql start although, I had to change bindir=./bin to bindir=/usr/local/mysql/bin to get it to work. I can access the DB with, mysql -h localhost -u root -p successfully, but, when trying to access via

Can't Access Via Webmin or PhpMyAdmin.

curious how you got it to run..? If I stop the server via cli and then click the start mysql server button on the webmin page, it goes back to the same message, but, the server is started. I changed the config module page to reflect my installation. What have I missed, perhaps..? Cheers. Mark

Re: MySQL not starting at boot-Fedora Core 3

Michael Stassen wrote: Mark Sargent wrote: Andy Pieters wrote: Hi Try to see in the log files cat /var/log/mysqld or start the mysql server and then type tail /var/log/messages On Fedora, once you have properly installed mysql there is no need to reboot your system to test it. Just type /sbin

Access denied-phpMyAdmin

'][$i]['user'] = 'root'; // MySQL user $cfg['Servers'][$i]['password'] = 'password is correct'; // MySQL password (only needed Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

MySQL not starting at boot-Fedora Core 3

from within the bin dir and I can connect as root or mysql. Cheers. /etc/init.dmysql permissions [EMAIL PROTECTED] init.d]# ls -lh mysql -rwxr-xr-x 1 root root 6.2K Apr 16 21:11 mysql Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: MySQL not starting at boot-Fedora Core 3

Andy Pieters wrote: Hi Try to see in the log files cat /var/log/mysqld or start the mysql server and then type tail /var/log/messages On Fedora, once you have properly installed mysql there is no need to reboot your system to test it. Just type /sbin/service mysql start other options you can

No Priviliges and no snort DB in phpmyadmin

should I look for to fix this..? Also, I have no priviliges for create database. Below is my connection info. Cheers. Welcome to phpMyAdmin 2.6.1-pl3 *MySQL 4.1.10a-standard running on localhost as [EMAIL PROTECTED] Mark Sargent. -- MySQL General Mailing List For list archives: http

The $cfg['PmaAbsoluteUri'] directive MUST be set in your configuration file!

to add the extension if I'm not using Japanese in any databases.? Cheers. $cfg['http://localhost/phpMyAdmin-2.6.1-pl3'] = ''; Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql not starting at boot

Hi All, below is my /etc/init.d/mysql content, but, mysql is not starting at boot on Fedora3. Have I missed something fundamental.? I need mysql to start at boot for snort to connect to it. Currently, snort gives an error stating it can't connect. Cheers. Mark Sargent. [EMAIL PROTECTED

Re: mysql not starting at boot

Tom Crimmins wrote: On Wednesday, March 30, 2005 23:26, Mark Sargent wrote: Hi All, below is my /etc/init.d/mysql content, but, mysql is not starting at boot on Fedora3. Have I missed something fundamental.? I need mysql to start at boot for snort to connect to it. Currently, snort gives

Re: [MySQL] mysql/snort/webmin/permissions

Mark Sargent wrote: Ashley M. Kirchner wrote: Mark Sargent wrote: [EMAIL PROTECTED] pcre-5.0]# mysql -h mysql -p -bash: mysql: command not found You don't have mysql in root's path. Once you fix that little problem, you should be all set. Hi All, heck, how exactly do I do that..? Move the whole

Re: [MySQL] mysql/snort/webmin/permissions

Ashley M. Kirchner wrote: Mark Sargent wrote: [EMAIL PROTECTED] pcre-5.0]# mysql -h mysql -p -bash: mysql: command not found You don't have mysql in root's path. Once you fix that little problem, you should be all set. Hi All, heck, how exactly do I do that..? Move the whole mysql dir to a path

mysql/snort/webmin/permissions

, 0 rows affected (0.02 sec) mysql exit bye I used webmin to create a new DB, snort, and gave permission to Username snort to create, insert, delete, select and update from host permissions. Is it the same as above..? 1st time to use webmin/mysql/snort/apache. Cheers. Mark Sargent. -- MySQL

Re: RES: phpmyadmin can't connect via browser

website for oldpassword or something, then you should find your answer. Regards Robert. -Mensagem original- De: Mark Sargent [mailto:[EMAIL PROTECTED] Enviada em: segunda-feira, 14 de março de 2005 01:35 Para: mysql Assunto: Re: phpmyadmin can't connect via browser Hassan Schroeder wrote

Stop the Server in Control Center not working

prompt..? I just get the following, [EMAIL PROTECTED] ~]# mysql Starting mysqld daemon with databases from /usr/local/mysql/data Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

phpmyadmin can't connect via browser

-2.6.1-pl3/Documentation.html#faqmysql /** * Your phpMyAdmin url * * Complete the variable below with the full url ie http://localhost/phpMyAdmin-2.6.1-pl3/ * What am I mising.? Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: phpmyadmin can't connect via browser

Hassan Schroeder wrote: Mark Sargent wrote: when typing localhost/phpMyAdmin-2.6.1-pl3/index.php, I get the following, cannot load mysql extension, please check PHP Configuration What am I mising.? Cheers. Uh, mysql support in your PHP installation? :-) What does phpinfo() show? Hi All, where

Re: phpmyadmin can't connect via browser

to change this line each time. Where mine has /phpmyadmin/, you will of course need to change that to the directory it is in. Steve Hi All, Steve, below is how It looks after your suggestions, but, still with the same errors. Cheers. Mark Sargent. /** * Your phpMyAdmin url * * Complete the variable

Re: phpmyadmin can't connect via browser

Mark Sargent wrote: Hassan Schroeder wrote: Mark Sargent wrote: when typing localhost/phpMyAdmin-2.6.1-pl3/index.php, I get the following, cannot load mysql extension, please check PHP Configuration What am I mising.? Cheers. Uh, mysql support in your PHP installation? :-) What does phpinfo

Re: phpmyadmin can't connect via browser

Hassan Schroeder wrote: Mark Sargent wrote: I'm figuring you wanted to know if php was working, yes..? No, I wanted to know if your PHP was compiled with MySQL support. It doesn't have to be, and in your case seems it probably *isn't*. But we still don't know :-) Hi All, guys, I'm using Fedora3

error 2002:

. Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: error 2002:

John Trammell wrote: Is the mysqld daemon running? (It should be.) What does the command ps aux | grep mysqld say? -Original Message- From: Mark Sargent [mailto:[EMAIL PROTECTED] Sent: Friday, March 11, 2005 8:52 AM To: mysql@lists.mysql.com Subject: error 2002: Hi All, I get

./mysql_install_db: line 86: my_print_defaults: command not found

--user=mysql ./mysql_install_db: line 86: my_print_defaults: command not found Could not find help file 'fill_help_tables.sql' in ./support-files or inside .. I guess I'm missing something quite fundamental, yes..? Just can't think what. Anyone see the obvious.? Cheers. Mark Sargent. -- MySQL

Permission Denied for INSTALL-BINARY

-BINARY -bash: ./INSTALL-BINARY: Permission denied What am I doing wrong here.? I'm rather new to Linux too. Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]