End Action [ failure 0x1602]
I have been using ODBC v3.51 to select from MySQL DB's hosted by a RH v7.2 Linux VM from within an application script. The DB's are normally imported in the early morning. I now have a need to Insert into a table from an application script. The insert works when submitted through phpMyAdmin. However, when the Insert statement is submitted via the application script, I get: End Action [ failure 0x1602] in the application log. The error seems to suggest that there is something wrong with my connector object. However, it is the same connector object I had been using for making select queries. The DBA says that I should have insert permissions. Any suggestions on how to proceed and deal with this issue would be greatly appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have been using ODBC v3.51 to access MySQL DB's hosted by a RH v7.2 Linux VM for select purposes f
I have been using ODBC v3.51 to access MySQL DB's hosted by a RH v7.2 Linux VM for select purposes from within an application script. They are normally imported in the early morning. I now have a need to Insert into a table from an application script. The insert works when submitted through phpMyAdmin. However, when the Insert statement is submitted via the application script, I get: End Action [ failure 0x1602] in the application log. Any suggestions on how to proceed and deal with this issue would be greatly appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Import databse ?
Isn't the default field separator in Linux a Tab character? I suspect it is. And, I also suspect that the default field separator in Solaris is not a Tab character. Check these out. If these are in fact true, then it might go a long way in explaining why your import failed. Vidhya CS [EMAIL PROTECTED] 07/30/03 01:17PM Hi , I am trying to export a database from one machine ie linux, and import the same database to another machine ie ,solaris . I exported the database using the following command . mysqldump -c -u vidhya ifmonitor $HOME/ifmonito.backup. this is ok , ifmonitor-backup has the table creation info as well as the table data . but when I try to import the same database to mysql in solaris m/c using the command mysqldump -u vidhya ifmonitor ifmonitor.backup It is showing the table creation info , but the actual data is not dumped . I am getting the following o/p -- MySQL dump 9.08 -- -- Host: localhostDatabase: ifmonitor - -- Server version 4.0.14-standard -- -- Table structure for table 'network' -- CREATE TABLE network ( device char(16) NOT NULL default '', timestamp int(14) default NULL, rx_bytes int(10) unsigned default NULL, tx_bytes int(10) unsigned default NULL, rx_drop int(10) default NULL, tx_drop int(10) default NULL, KEY timestamp (timestamp), KEY device (device) ) TYPE=MyISAM; -- -- Dumping data for table 'network' -- bash-2.05$ The table has nearly 358 records and those records has not been imported to ifmonitor database . how do I correct this . any idea? thanks Vidhya -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error code 1064 in another application...
If your query has worked in one account, but not in another, then your 1064 error is
probably related to privileges granted to the second account.
HTH
Ola Ogunneye [EMAIL PROTECTED] 07/29/03 09:08AM
I am running mysql 4.0.13 and using a weblog(Geeklog) to do my web.
Using geeklog as been okay until I tried creating moderators to my forum
and then I got the following error:
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 '' at line 1
My intuition is that because I start mysql as a service in win2k and so
each time I log onto my Win2k Server, mysql is running already. I
however log into win2k with username Administrator, while mysql root
user has been changed to my name ola, I believe that user Ola has all
the rights with the following setup string:
mysql delete from user where Host='%';
mysql delete from user where User='';
mysql delete from db where Host='%';
mysql update user set User='ola', Password=password('olapassword')
where User='root';
mysql flush privileges;
With the above, I was able to create 3 databases, and I believe that
because of the above, then user ola is now the root user and should be
able to grant privileges to other users
Does user ola need to be granted privileges in each database created
after executing the above commands or are they inherited since user ola
is now the root user?
Would manually starting Mysql with user ola correct the error 1064 that
I got from the other application?
Thanks in advance...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL error code 1064:K@N@!:
I have managed to successfully run the following MySQL statement directly on the server hoasting MySQL: insert tblMealCounts set ProgramCode = '140', yymmdd = '030725', MealCode = '2', MealCount = '11'; And, I can view the table afterwards and see the record ok. when I run it from an application - ng. Could there be a problem with my ODBC driver? Here is its description: MySQL ODBC 3.51 Driver DSN. It is running on an old WinNT box with SP6a applied, and accessing a MySQL server running on a virtual RedHat v7.2 server. I have been able to do any selects I want ok. This is my first attempt to insert. David Precious [EMAIL PROTECTED] 07/25/03 11:54 AM On Friday 25 July 2003 1:05 pm, Kenneth Illingsworth wrote: I cannot seem to find this in the MYSQL Reference. Are there other places I should check? It's a syntax error. A quick Google (http://www.google.com/search?q=mysql+error+1064) would have found it for you. The message text in my log started out with 'You have...'. But, it was truncated and I could not see the rest. It would have been saying You have an error in your SQL syntax near It occurred on a submitted insert statement originating in an application. The insert statement works ok directly on the MySQL server. It would appear that the application is generating the INSERT statement incorrectly. HTH! David Precious http://www.preshweb.co.uk/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fwd: MySQL error code 1064:K@N@!:
I suspect that this is some kind of issue with privileges. However, the account I am using has been given 'ALL' privileges to the database I am trying to insert to. Am I save to assume that ALL includes insert privileges? ---BeginMessage--- I cannot seem to find this in the MYSQL Reference. Are there other places I should check? The message text in my log started out with 'You have...'. But, it was truncated and I could not see the rest. It occurred on a submitted insert statement originating in an application. The insert statement works ok directly on the MySQL server. The ODBC connector performs its function in the application without any errors. Thanks in advance for any direction you can give. ---End Message--- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL error code 1064
I cannot seem to find this in the MYSQL Reference. Are there other places I should check? The message text in my log started out with 'You have...'. But, it was truncated and I could not see the rest. It occurred on a submitted insert statement originating in an application. The insert statement works ok directly on the MySQL server. The ODBC connector performs its function in the application without any errors. Thanks in advance for any direction you can give. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL error code 1064
I streamlined the application so as to target the offending object more precisely for testing purposes. And, now the error is 1602 with no text. I am currently still looking for any error references. Once again, thanks in advance for your time. Kenneth Illingsworth [EMAIL PROTECTED] 07/25/03 08:05AM I cannot seem to find this in the MYSQL Reference. Are there other places I should check? The message text in my log started out with 'You have...'. But, it was truncated and I could not see the rest. It occurred on a submitted insert statement originating in an application. The insert statement works ok directly on the MySQL server. The ODBC connector performs its function in the application without any errors. Thanks in advance for any direction you can give. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL error code 1064
I found the following by performing a google search: 1602 Btree unpacked page size (from header) does not match size loaded from disk Not sure what this means, but still looking for a better error reference. The link found in the google search was: http://www.clarionmag.com/cmag/v1/v1n1tpserrorcodes.html Kenneth Illingsworth [EMAIL PROTECTED] 07/25/03 08:07 AM I cannot seem to find this in the MYSQL Reference. Are there other places I should check? The message text in my log started out with 'You have...'. But, it was truncated and I could not see the rest. It occurred on a submitted insert statement originating in an application. The insert statement works ok directly on the MySQL server. The ODBC connector performs its function in the application without any errors. Thanks in advance for any direction you can give. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fwd: Re: MySQL error code 1064
I found a syntax error which caused the 1602 error and corrected it. I am now back to struggling with the '1064 - You have...' error. Unfortunately, I have been unable to find any reference to this particular error. ---BeginMessage--- I streamlined the application so as to target the offending object more precisely for testing purposes. And, now the error is 1602 with no text. I am currently still looking for any error references. Once again, thanks in advance for your time. Kenneth Illingsworth [EMAIL PROTECTED] 07/25/03 08:05AM I cannot seem to find this in the MYSQL Reference. Are there other places I should check? The message text in my log started out with 'You have...'. But, it was truncated and I could not see the rest. It occurred on a submitted insert statement originating in an application. The insert statement works ok directly on the MySQL server. The ODBC connector performs its function in the application without any errors. Thanks in advance for any direction you can give. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] ---End Message--- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fwd: MySQL error code 1064
I suspect that this is some kind of issue with privileges. However, the account I am using has been given 'ALL' privileges to the database I am trying to insert to. Am I save to assume that ALL includes insert privileges? ---BeginMessage--- I cannot seem to find this in the MYSQL Reference. Are there other places I should check? The message text in my log started out with 'You have...'. But, it was truncated and I could not see the rest. It occurred on a submitted insert statement originating in an application. The insert statement works ok directly on the MySQL server. The ODBC connector performs its function in the application without any errors. Thanks in advance for any direction you can give. ---End Message--- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL error code 1064
I have managed to successfully run the following MySQL statement directly on the server hoasting MySQL: insert tblMealCounts set ProgramCode = '140', yymmdd = '030725', MealCode = '2', MealCount = '11'; And, I can view the table afterwards and see the record ok. when I run it from an application - ng. Could there be a problem with my ODBC driver? Here is its description: MySQL ODBC 3.51 Driver DSN. It is running on an old WinNT box with SP6a applied, and accessing a MySQL server running on a virtual RedHat v7.2 server. I have been able to do any selects I want ok. This is my first attempt to insert. David Precious [EMAIL PROTECTED] 07/25/03 11:54 AM On Friday 25 July 2003 1:05 pm, Kenneth Illingsworth wrote: I cannot seem to find this in the MYSQL Reference. Are there other places I should check? It's a syntax error. A quick Google (http://www.google.com/search?q=mysql+error+1064) would have found it for you. The message text in my log started out with 'You have...'. But, it was truncated and I could not see the rest. It would have been saying You have an error in your SQL syntax near It occurred on a submitted insert statement originating in an application. The insert statement works ok directly on the MySQL server. It would appear that the application is generating the INSERT statement incorrectly. HTH! David Precious http://www.preshweb.co.uk/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Altering table and field names
I would like to copy the values from each record in the Program table to another table (tblPrograms). This is the syntax I came up with: select * from Program insert tblPrograms set ProgramCode=Location, ProgramName=Description; However, it fails without telling me why. Perhaps someone could correct me or re-direct me on this issue? Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql.Sock problem
It appears that we both are climbing the same mountain. The best approach is to hire a consultant to come in and get you started in the right direction. If, as is our case, this is unlikely, I will attempt to relay to you some of what I have encountered so far. Typically we prefer downloading RPM files rather than tarball files. The RPM files are utilized better by an application called WEBMIN (www.webmin.org) . I am going to recommend that you familiarize yourself with Webmin very thoroughly. By clicking on the SYSTEM button, you can then select the SoftWare Packages icon, and then the Package Tree to see what your server has installed. Or, you can uninstall programs that you will not need. The Bootup and Shutdown icon will allow you to start applications and to specify what ones you want started when the Linux server is booted. We encountered some horrific problems trying to instal MySQL from a taball file that just seemed to go on and on. However, using Webmin and corresponding RPM files to install MySQL, we had no problem at all. Plus, we can now see live examples of how MySQL is supposed to have been set up. Never having seen a working setup before, this proved to be very valuable. Finally, you want to access your MySQL database from your browser, you will more than likely have to familiarize yourself with PHP (personal home page). It is also downloaded as an RPM file. Note: you must install the RPM module that allows PHP applications to utilize MySQL databases. HTH LeVar Bery [EMAIL PROTECTED] 12/31/02 07:19AM I had this same problem... for 4 Days! Check the permission on the /var/lib/mysql directory. Check the logs /var/logs/mysql.log to make sure its not crashing or not connecting Check the permissions on the /var/run/mysql it should have rwxr-xr-x mysql mysql (this was my problem) I thought I was being cool by using: chown ./* to change the of all the files in my /var/www directory. I didn't realize I had change everything in ../ which changed ownership on everyting in the /var structure - Original Message - From: A.T.Z. [EMAIL PROTECTED] To: Jason Steig [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, December 31, 2002 1:59 AM Subject: RE: Mysql.Sock problem Is mysql running (ps -axu) if not: /path/to/safe_mysqld --user=mysql This is explained in the docs -Oorspronkelijk bericht- Van: Jason Steig [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 31 december 2002 9:08 Aan: [EMAIL PROTECTED] Onderwerp: Mysql.Sock problem I' am relatively new to MySQL and I 'am having a problem with starting the ./mysql program I always get the mysql.sock error. I know this mysql.sock file is used when the local machine is the mysql server. Likewise I can't start mysql.server or mysqld. I' am trying to start it as root. I know this is not a good practice. The first think I have to do is (./mysql -u (User) password). This is what allows me to create a user to run mysqld? Correct? - 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 - 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 - 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: Help struggling newbie, please!!
You might also wish to consider downloading and installing Webmin. It's one of the easiest installs I have encountered. Simply tar the tarball and proceed into the new subdirectory (IE webmin-1.030) and perform a /setup.sh . Webmin will allow you easy access to your server via a web browser. Simply enter http://serverip:1/ after the installation. To manage your MySQL databases, simply left-click on the Server button and select the MySQL server icon. You should be able to accomplish a great deal with this GUI. For tasks not covered by Webmin, you will need to familiarize yourself with Telnet. If, as was the case with our distribution, Telnet is disabled by default, you will need to familiarize yourself with PuTTY.exe for accessing your server via a secure shell. GL Victoria Reznichenko [EMAIL PROTECTED] 12/17/02 08:02AM On Tuesday 17 December 2002 13:56, Martin Finnegan wrote: I am trying to get a handle on MySQL anticipating a PHP application I want to implement on a website next year. I am using WinXP and the website is on a Linux server. I have created a new database, but am having problems creating tables. Its not too obvious how to go about it. I have consulted the manual but of course its all Linux based. I want to get an application called phpMember ver 0.1.0 ( http://product.cybergl.co.id/dev/expose.php?cmd=installversion_id=53 ) working. Point 2 of the installation says: Create the required tables within your website databse as provided in phpMember.sql You can use the mysql-client for this: mysql (db-name) phpMember.sql Any tips about how I can do this in Windows? I can't figure out how the hell I'm supposed to do this. I'm used to using ASP and just creating an Access DB. I did a bit of PHP a couple of years ago with postgres but its all a bit hazy now. Maybe I'm way off track here - I sure could use a few pointers. On Windows you can do the same in the DOS prompt. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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 - 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: Can't find hosts.frm -- permissions now okay?
I had a similar experience right down to the error message you are getting. Based on that experience, I am inclined to recommend the following: 1) Abandon your current installation which I perceive that your are attempting from a MySQL tarball. 2) Download the webmin-1.030 tarball and execute ./setup.sh after exploding the tarball with tar -xzvf webmin-1.030.tar.gz . 3) Download the RPMs for MySQL instead of the tarball you are now using. 4) Use webmin to install the RPMs. This was much easier for me. GL Lefevre, Steven [EMAIL PROTECTED] 12/12/02 03:17PM I'm still getting the error 'Can't find hosts.frm' when I try to laund the mysql daemon. I've run the mysql_install_db script several times. I've changed the user and group ownership for all the files in the /usr/libexec/mysql directory, and also in /var/lib/mysql to 'mysql' (it was 'root'). (RPM installed it originally in /var/lib/mysql, I copied it to /usr/libexec/mysql just in case that's where is was looking. That's where th mysqld was, and the error said can't find ./hosts.frm.) Any ideas? ls -la /var/lib/mysql/ total 120 drwxr-xr-x4 mysqlmysql4096 Dec 12 15:03 . drwxr-xr-x 13 root root 4096 Dec 6 10:07 .. ... -rw-rw1 mysqlmysql1024 Dec 6 11:10 func.MYI -rw-rw1 mysqlmysql8958 Dec 6 11:10 host.frm -rw-rw1 mysqlmysql 0 Dec 6 11:10 host.MYD ... ls -la /usr/libexec/mysql total 116 drwxr-xr-x3 root root 4096 Dec 11 15:30 . drwxr-xr-x7 root root 4096 Dec 11 15:28 .. ... -rw-r-1 mysqlmysql1024 Dec 11 15:29 func.MYI -rw-r-1 mysqlmysql8958 Dec 11 15:29 host.frm -rw-r-1 mysqlmysql 0 Dec 11 15:29 host.MYD ... - 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 - 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
Install PHP with MySQL
I recently installed the following RPM's: MySQL-3.23.41-1a.s390.rpm MySQL-devel-3.23.41-1a.s390.rpm MySQLclient9-3.23-22-6a.s390.rpm MySQL-server-3.23.41-1a.s390.rpm Afterwards, I was able to start the mysqld daemon ok and install an application I downloaded for a demonstration of the viability of the Linux VM on s390 platform. The application url is http://epayroll.sourceforge.net/ and it required mysql v3,22x or higher, Apache running as a webserver, and PHP v4.0.2 or higher (mine is v4.0.6). However, when I finally attempted to log into this application, I got the following error: Fatal error: Call to undefined function: mysql_connect() in /var/www/html/eps/datacon.php on line 14 I contacted the author of this application who suggested that I reinstall PHP with the mysql option enabled. Towards that end, I downloaded and installed the php-mysql-4.0.6-15.s390.rpm file. Unfortunately I got the same error. I am somewhat certain that the author of this application was on the right track. Would anyone on this forum care to offer me any direction on this matter? Thank you in advance for your time. - 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
Error starting the Mysql Daemon
After taring mysql-3.23.53-unknown-linux-gnu-s390.tar.gz successfully on our Linux VM and linking the new directory to simply mysql, I ran into the following error trying to start the mysql daemon: [root@cofr3 mysql]# ./bin/mysqld -L /mysql/share/mysql/english Fatal error: Please read Security section of the manual to find out how to run mysqld as root! 021122 12:13:59 Aborting 021122 12:13:59 ./bin/mysqld: Shutdown Complete --- I took this error to simply mean that I needed to execute the following commands: chown -R root /mysql chown -R mysql /mysql/data chgrp -R mysql /mysql Unfortunately, I still got this error. Can anyone see what I am missing? P.S. I am able to run ./bin/mysqladmin --version command successfully. However, PS -ax does not show mysql running. I also tried ./bin/safe_mysqld --user=mysql and got the following: [root@cofr3 mysql]# ./bin/safe_mysqld --user=mysql Starting mysqld daemon with databases from /var/lib/mysql 021122 12:31:41 mysqld ended --- Thank you in advance for your time. Regards, Ken Illingsworth - 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
Fatal error: Please read Security section of the manual tofind out how to run mysqld as root!
This happens when I try to start the mysql daemon. I have checked the manual, but cannot fathom what else I am supposed to do. Here is what has been done so far: ./scripts//mysql_install_db seemed to initialize the MySQL db's ok. I also executed the following statements without issue: chown -R root /usr/local/mysql chown -R mysql /usr/local/mysql/data chgrp -R mysql /usr/local/mysql ./bin/mysqladmin --version dows return the version of MySQL ok. ./bin/safe_mysqld --user=mysql and got the following: [root@cofr3 mysql]# ./bin/safe_mysqld --user=mysql Starting mysqld daemon with databases from /var/lib/mysql 021122 12:31:41 mysqld ended Regards, Ken Illingsworth - 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
Bind on unix socket: Permission denied
Mysqld.log shows this error: 021122 11:29:05 mysqld started 021122 11:29:06 Can't start server : Bind on unix socket: Permission denied 021122 11:29:06 Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ? -- Note: I cannot even find a mysql.sock on this system, but have changed my.cnf to specify socket=/tmp/mysql.sock should the system ever get a chance to create it. And, have added port=3306 to the mysqld section. Furthermore, why is there not mysqld.pid file on this system? Is it not requried? Regards, Ken Illingsworth - 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
epayroll
Anyone have experience with Hotscripts Enterprise Timesheet and Payroll application? It's my first attempt at running a MySQL aplication. Here is the link: http://www.hotscripts.com/Detailed/14498.html The installation seemed to go flawlessly. Apache webserver was running as well as MySQL v3.2.3.x, and the payroll.sql script created the tables as advertised. However, I could not seem to authenticate with uid admin and pw eps as per instructions. Anyone with working samples of this appication? I would like to see what your datacon.php and settings.php files look like. Thanks in advance for your time. Regards, Ken Illingsworth - 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
