Unable to access primary key
I get an error Unable to access primary key each time I attempt to insert or update a record. But everything seems to be OK with my PK. CHECK TABLE doesn't see any problem. Any idea ? Regards. Stéphane -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Unable to access primary key
I get an error Unable to access primary key each time I attempt to=20 insert or update a record. But everything seems to be OK with my PK.=20 CHECK TABLE doesn't see any problem. Any idea ? Regards. Stéphane -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
issues with mysql
I've installed 3.23.53 on a MacOS X box. verything seems to be OK except: when I use mysql like this : /usr/local/bin/mysql test ..no problem. but if I want to use any option like : /usr/local/bin/mysql test -u I get a zillion lines that start with ./bin/mysql Ver 11.18 Distrib 3.23.53, for apple-darwin6.2 (powerpc) Copyright (c) 2000 MySQL AB MyQL AB Finland ...etc... ..then the lines continue with: Usage: ./bin/mysql [OPTIONS] [database] ..ect ect ect... ...then I'm dropped back at: [wallstreet:~] spinel% I've never seen this before. mysqld is running but I'm unable to create a user with privileges. Any idea ? Regards. --- Stéphane Pinel Information System Equinox Partners Paris iChat/AIM: s.pinel --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysqld to listen from an other port than 3306
What is the best strategy to make mysqld listen from another port than 3306 ? In fact we have 2 servers that handle mysql. The first is listening at port 3306 but we need that the second one listen from another port in order to run in our local network IP Port Mapping What is the simple way to do that ( MacOS X ). Thanks. -- Stéphane Pinel Equinox Partners France Information System - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysqld to listen from an other port than 3306 (2)
What is the best strategy to make mysqld listen from another port than 3306 ? In fact we have 2 servers that handle mysql. The first is listening at port 3306 but we need that the second one listen from another port in order to run in our local network IP Port Mapping What is the simple way to do that ( MacOS X ). Thanks. -- Stéphane Pinel Equinox Partners France Information System - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysqld to listen from an other port than 3306 (2)
Le 7/10/02 7:33, « Iikka Meriläinen » [EMAIL PROTECTED] a écrit : On Mon, 7 Oct 2002, Stéphane Pinel wrote: What is the best strategy to make mysqld listen from another port than 3306 ? In fact we have 2 servers that handle mysql. The first is listening at port 3306 but we need that the second one listen from another port in order to run in our local network IP Port Mapping What is the simple way to do that ( MacOS X ). Hi, Consider using --port=1234 parameter to mysqld. Yes but if the server is down and need to be restart, this will cause some troubles... Also, if Mac OS supports it, you can specify those parameters along with numerous others in my.cnf. I've tried using my.cnf but it doesn't work for me. Is someone knows where to put this file in a MacOS X binaries installation (Marc Liyanage Packages) ? Thanks. -- Stéphane Pinel Equinox Partners France Information System - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: install mysql on osx 10.2
Le 1/10/02 19:51, « webmaster » [EMAIL PROTECTED] a écrit : Hi, I am looking for some help installing mysql I have downloaded a copy and have it on my desktop , and well I am sorta wondering where to go from here. Because the instructions are too vague for me, as a newbie to mysql please assist james You'd better get the Marc Liyanage package and follow his very clear and understandable instructions: http://www.entropy.ch/software/macosx/mysql/ Regards. -- Stéphane Pinel Equinox Partners France Information System - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[NEWBIE] Master Account
I've just installed MySQL on a MacOS X 10.2 system. Everything is OK but I can't find how I can login as a master to create users and give privileges ? Thanks. -- S.PINEL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php