Prevent MySQL From Starting At Startup
I'm starting to play around with MySQL. How can I prevent it from starting up whenever my computer starts? It slows down the startup some, and I'm not always wanting to use it. besides, I can start it myself if I need it.I've had a look on Google for theis, and found quite a few results, but they were fo Linux or Unix. I'm ruinning Windows XP.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Prevent MySQL Locking Up
I was doing some major work using MySQL this weekend, and I realized that MySQL is quite fragile. I mean, it can lock up so easily, and it's not funny. How can you prevent MySQL from locking up? What things can we really do so that MySQL doesn't lock up the entire server so easily?
How To Prevent MySQL Queries From Taking Too Long
I have a very busy database with some tables having hundreds of thousands of records. I am running MySQL 5.0.16 on Windows. Some of the queries running on my database are not fined-tuned enough, and need improvement. However, the system is live in production and I am looking for a way to prevent MYSQL from committing Harakiri, i.e. from running very slow queries forever, taking the cpu to 50% and beyond for hours. My scripting language is PHP. I found that after a while the end user receives a timeout on the browser, but MySQL continues trying to run the query, sometimes for hours. My question is, is there a way to specify a timeout for MySQL so that it will abort any queries that it is running that have not returned a result by then. The end user is no longer around anyway, so I am looking for a way to protect the database resources (and in parallel I will start investigating how to optimize the slow queries).
Prevent Copying From Mysql Data Tables ?
Recently we had to move some of our databases to the clients site onto their linux server. Can someone hint on how to prevent "the clients" from snatching our data and db schema? The drawback: they do own the machine - hence they do have a root password, therefore even if I change the unix permissions on the mysql directories - they are still open to the "root".
MySQL Startup
i dowunloaded the sources of mysql 4, i compiled it under slackware 9...no errors on configure, make & make install.... I created db (mysql_install_db) and root db password (mysqladmin root -u password) and no errors. The problem is that when i type mysqld_safe & i get the following error : ./mysqld_safe & [1] 5113 root@darkstar:/usr/local/mysql/bin# Starting mysqld daemon with databases from /usr/local/mysql/var 030624 12:33:22 mysqld ended .
Install And Startup Mysql
I cant get mysql to run on my winXP computer. I have downloaded it and installed , unzipped and run setup.exe and placed it in c:mysql. I type the command to start the mysql server c:mysqlinmysqld --console It opens the console and then the console shows some inoDB commands and the console hangs. I followed the mysql manual and i cant find the answer there is no command prompt and nothing...how do I run mysql?
Mysql Freezes On Startup
I've got a mysql server running on linux. It was working fine until this morning when a customer wrote and told me it was not working. On investigation it had frozen. I stopped and restarted it this is on an fc3 box, i get the starting mysql message but never get a prompt back. I don't see any output in my /var/log/messages.1 file.
Mysql Startup Script
I have mysql running on a freebsd box. When the machine boots it does not automatically start mysql, despite "mysql-server.sh-dist" being in the /usr/local/etc/rc.d file. This means that I must run "/usr/local/etc/rc.d/mysql-server.sh-dist start" manually to get mysql to start. Does anyone know of a way to make mysql start automatically when the freebsd box starts?
Can't Startup Mysql Server
I hv just kill the mysql server process ( by killing the process ID ) , not normally shutdown the mysql server ( mysql stop ) , now the mysql can't start , I also can't find any process related to mysql , except reboot the server , can suggest how to start the server again ?
MySQL Startup Scripts
Would anyone explain me why the startup scripts check for command line arguments and the contents of /etc/my.cnf right after setting the env variables such as basedir, pid-file and so? if the MySQL code and scripts are expected to be on a specific hardcoded location (yeah, right we could specify this at build time) why bother supporting those variables at all? shouldn't they run parse the command line and defaults file first before setting defaults.
Mysql Shell Startup Script
When starting up the mysql shell, is there a way that I can automatically run a startup-script ? Specifically, I would like to issue a BEGIN WORK everytime I open up the shell. I tried man mysql, but didn't get any the wiser.
MySQL Error (*not* 1067) Soon After Startup On XP Pro
I had this problem with 4.0.17 so I upgraded to 4.0.20D, alas with to no avail. I could install the service succesfully with mysqld --install. When I started the service I got a message saying "The MySQL service was started succesfully" but a second later it died. Windows popped up with the usual message "mysqld has encountered a problem and needs to close....blah....blah". The details of that error is as follows: ================================================ szAppName : mysqld.exe szAppVer : 0.0.0.0 szModName : unknown szModVer : 0.0.0.0 offset : 00000000 ================================================ Similar thing happened when I tried to do mysqld --console. I got the "mysqld has encountered......blah" with the following details in the error message: ================================================ AppName: mysqld.exe AppVer: 0.0.0.0 ModName: mysqld.exe ModVer: 0.0.0.0 Offset: 00257865 ================================================ This also applies to another binary which I normally use, max-nt. There's more to the error messages but they're too long to include in this post. Does anyone have any idea what this means?
MySQL Server Startup Issues
For some reason I cannot get my MySQL server to start. It has been running fine until Friday, when we has a strange issue with the Solaris server which it is running on. The server had a few files get their chmod setting messed up and now after fixing that, MySQL won't start. Exerpt from neuro18.err: 040830 15:55:19 mysqld started 040830 15:55:19 Can't start server : UNIX Socket : Permission denied 040830 15:55:19 Aborting 040830 15:55:19 /usr/local/mysql-standard-4.0.20-sun-solaris2.8-sparc/bin/mysqld: Shutdown Complete 040830 15:55:19 mysqld ended ps -ef|grep mysql yeilds no other mysqk processes running. ls -l in /usr/local/mysql yeilds: -rw-r--r-- 1 root mysql 19106 May 13 20:14 COPYING -rw-r--r-- 1 root mysql 8403 May 13 20:14 INSTALL-BINARY -rw-r--r-- 1 root mysql 1937 May 13 19:53 README drwxr-xr-x 2 root mysql 1536 May 13 21:59 bin -rwxr-xr-x 1 root mysql 773 May 13 21:59 configure drwxrwxr-x 9 mysql mysql 512 Aug 30 15:55 data drwxr-xr-x 2 root mysql 512 May 13 21:59 docs drwxr-xr-x 2 root mysql 1536 May 13 21:59 include drwxr-xr-x 2 root mysql 512 May 13 21:59 lib drwxr-xr-x 3 root mysql 512 May 13 21:59 man drwxr-xr-x 6 root mysql 512 May 13 21:59 mysql-test drwxr-xr-x 2 root mysql 512 May 13 21:59 scripts drwxr-xr-x 3 root mysql 512 May 13 21:59 share drwxr-xr-x 5 root mysql 1024 May 13 21:59 sql-bench drwxr-xr-x 2 root mysql 512 May 13 21:59 support-files drwxr-xr-x 2 root mysql 512 May 13 21:59 tests...
MySQL 4.020c (Windows) Service Startup Error
I installed MySQL 4.0.20C and it works if I started it with mysqld --console However, if I do the following: mysqld --install net start MySQL I got the following error: D:mysql>net start MySQL The MySQL service is starting. The MySQL service could not be started. A system error has occurred. System error 1067 has occurred. The process terminated unexpectedly. Does anyone know what I have don't wrong? I was using Windows XP on my notebook with latest security patches applied.
Prevent Writes
How can I prevent writes to a mysql database but at the same time allow reads? This is in the case where I have a master/slave. The master got hosed so I promoted slave. Now I have the master back up and want to swap it back. So I need to stop writes to the slave, take a mysqldump, put it on the master and then start calling the master for writes.
Prevent ON UPDATE CURRENT_TIMESTAMP
Does anybody know if there is a way to prevent an ON UPDATE CURRENT_TIMESTAMP from occuring if I don't want it to? Only way I can see to do it is by altering the column properties to just a TIMESTAMP field, do the update, then alter the column back.
Starting MYSQL On A Mac
I feel quite stupid I cannot seem to get MYSQL to even run on my Mac (OS X 10.4) I have installed MYSQL and then went to terminal and entered cd /usr/local/mysql then sudo ./bin/mysqld_safe then my password as prompted which is followed by Starting mysqld daemon with databases from /usr/local/mysql/data - at this point as it just seems to stop What next? I have tried entering mysql -u grifkerry -p but nothing happens! I have left it for a while but still nothing.
Starting MySQL
I need to transfer a database from one computer to another. Both computers are Macintoshes running OS X Panther. Both computers are running MySQL through localhost. The computer to which I am transferring the database has MySQL up and running perfectly fine. The computer from which I want to get the database is able to query the database through a web application using Perl but when I try to run MySQL from the Unix command line using the following text: "mysql -h localhost -u root -p" I get the following response "-sh: mysql: command not found." As far as I know, MySQL is installed correctly on this machine (I would assume it has to be in order for the web application to access the database through Perl and MySQL). If I can start and run MySQL, I know that I can dump the database using the "mysqldump" command. Does anyone have any suggestions on what I need to do to get the mysql command to execute correctly so that I can run the program?
Starting Mysql
im a complete novice regarding mysql im am trying to start mysql with c: et start mysql and get the system error 1067
Starting Mysql
I used to have an older version of Mysql (4.0) that I started by starting Winmysqladmin. Now I replaced this with the newest version: 4.1.12 and that doesn't have Winmysqladmin. After some experimentation I found out that MYSQLD.EXE seems to start mysql. I can then use phpMyAdmin. However, my own application still does not work (I can log in, but my queries give no results). A possible explanation is that I selected the UTF-8 fontset. I would like to have advice of what causes this problem and how I can solve this. I a using Windows ME.
Starting Mysql
I am using window xp, I installed mysql 4.0 and it was working fine. last week, I uninstalled mysql 4.0 and install 4.1 and it's no longer starting. before, error message said, "mysql failed start, wait 30 then try again" then I messed around with it. the error message is gone right now, it doesn't start, it doesn't give me any error message and I can't even get mysql 4.0 working.
Mysql Not Starting
I had to reload mysql 4.0.17 on to a Fedora Core machine that was previously working in the same configuration. Now though I can't get the server to run with the either of the following commands: ../mysql.server start - the command line reappears with no error but no running process in the system monitor /usr/local/mysql/bin/mysqld_safe -user=mysql - this command does not return to the command prompt so when I hit the enter key I get "Starting mysqld daemon with databases from /var/lib/mysql 0404124 00:13:21 mysqld ended. It looks to me as if it attempts to start but fails with no error. What am I missing on the reinstall?
Starting Mysql
This may be a very simple question and possibly could have a very simple solution to it.Since I have been using mysql for less than 2 months,I still consider myself a newbie.I still cannot execute certain commands from my dos prompt, but I can run queries easily using phpmyadmin.I have purchased MYSQL Second Edition (Paul Dubois) so I hope to put it to good use soon. The question that is of concern to me this morning is the prefered way to start mysql.I seem to think that I always have a problem because when I start my PC,mysql is already running as a service.But I am thinking that because I login to my PC as any user other than the dbase username,I have a problem afterwards. Must I always log on to my PC (Win2K) as the same user as the created user in my DBase in order for mysql to run properly?
Starting MYSQL...
--=_5D034890.F392DE43 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit This may be a very simple question and possibly could have a very simple solution to it. Since I have been using mysql for less than 2 months, I still consider myself a newbie.... I still cannot execute certain commands from my dos prompt, but I can run queries easily using phpmyadmin. I have purchased MYSQL Second Edition (Paul Dubois) so I hope to put it to good use soon.... The question that is of concern to me this morning is the prefered way to start mysql. I seem to think that I always have a problem because when I start my PC, mysql is already running as a service. But I am thinking that because I login to my PC as any user other than the dbase username, I have a problem afterwards. Must I always log on to my PC (Win2K) as the same user as the created user in my DBase in order for mysql to run properly?
Starting Mysql 5.0.18
I type in the password and mysql closes. When I reinstall it as an anonymous user mysql asks me to type in my password. I've reinstalled the program a few times. I tried to reset the root password. None of these things work. I also saw that I have a file called prod.err. I open up the file and I see a bunch of stuff that I don't understand. I greatly appreciate anyone who could help me solve this problem. I've run out of ideas. prod6.err: InnoDB: The first specified data file .ibdata1 did not exist: InnoDB: a new database to be created! 060215 16:31:56 InnoDB: Setting file .ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 060215 16:31:56 InnoDB: Log file .ib_logfile0 did not exist: new to be created InnoDB: Setting log file .ib_logfile0 size to 10 MB InnoDB: Database physically writes the file full: wait... 060215 16:31:57 InnoDB: Log file .ib_logfile1 did not exist: new to be created InnoDB: Setting log file .ib_logfile1 size to 10 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 060215 16:31:57 InnoDB: Started; log sequence number 0 0 060215 16:31:58 [Note] C:Program FilesMySQLMySQL Server 5.0inmysqld-nt: ready for connections. Version: '5.0.18-nt' socket: '' port: 3306 MySQL Community Edition (GPL) 060215 16:52:38 [Note] C:Program FilesMySQLMySQL Server 5.0inmysqld-nt: Normal shutdown 060215 16:52:39 InnoDB: Starting shutdown... 060215 16:52:40 InnoDB: Shutdown completed; log sequence number 0 43655 060215 16:52:40 [Note] C:Program FilesMySQLMySQL Server 5.0inmysqld-nt: Shutdown complete
Starting Mysql
--=_81DF9BED.E485C8BC Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Hello gang, This may be a very simple question and possibly could have a very simple solution to it. Since I have been using mysql for less than 2 months, I still consider myself a newbie.... I still cannot execute certain commands from my dos prompt, but I can run queries easily using phpmyadmin. I have purchased MYSQL Second Edition (Paul Dubois) so I hope to put it to good use soon.... The question that is of concern to me this morning is the prefered way to start mysql. I seem to think that I always have a problem because when I start my PC, mysql is already running as a service. But I am thinking that because I login to my PC as any user other than the dbase username, I have a problem afterwards. Must I always log on to my PC (Win2K) as the same user as the created user in my DBase in order for mysql to run properly?
Starting MySQL
I have a strange problem with mysql start. In normal procedure I do not see any problem. I have my product patch (a tar file) and when I try to untar this under /tmp directory and try to start MySQL, it is not getting started. The tar file has following files extracted to /tmp folder 1. install 2. clearevents.sh 3. ClearEvents.class 4. README.txt 5. cleareventscron.txt If I extract this tar file to some other folder, say /test, I do not see any problem in starting the SQL.Is there any conflict with the file names which I am using here? Some one please help me in clarifying this issue.
How To Prevent Stop Words In A MATCH - AGAINST?
I have a simple search engine for my website, and the MATCH-AGAINST works well when search english words (contained in the `name` and `desc` columns), but when try to search a item-code contained in the `sku` column it seems like mysql handle that code (such as "hp-504") as a stop word and returns zero rows...
Prevent Users Creating Their Own Databases
I've installed 4.0.22 and phpMyAdmin 2.6.0-pl2 and followed the instructions, removed the "guest" accounts. Granted users ALL privs on their own db only, which I created. Globally users just have the USAGE priv, no create priv but users can still create their own databases which I need to prevent. What am I missing ?
Prevent One Field Form Overlaping Another
I have the following table: lesson { id int, lesson_start int, lesson_end int, PRIMARY KEY(id) } No lesson can overlap another. So I can't have rows like: id | lesson_start | lesson_end 1 | 12:00 | 14:00 2 | 13:00 | 15:00 Is there any way to deal with it from the MySQL level?
Prevent Multiple User Registrations
What's the best way to prevent someone from registering multiple accounts on my website? Should I create a column called "IP Address" in the members table and make it UNIQUE? Are there any complications with this?
Problem On Starting MySQL
Ubuntu-6.06-LAMP-server-amd64 I followed section "10 MySQL" on; http://www.howtoforge.com/perfect_setup_ubuntu_6.06_p4 and found "libmysqlclient12-dev" not installed. After installing it MySQL unabled to start. I reinstalled all packages recommended there. $ sudo apt-get install --reinstall mysql-server mysql-client libmysqlclient12-dev Password: Reading package lists... Done Building dependency tree... Done 0 upgraded, 0 newly installed, 3 reinstalled, 0 to remove and 8 not upgraded. Need to get 0B/3305kB of archives. After unpacking 0B of additional disk space will be used. Do you want to continue [Y/n]? (Reading database ... 82866 files and directories currently installed.) Preparing to replace libmysqlclient12-dev 4.0.24-10ubuntu2 (using .../libmysqlclient12-dev_4.0.24-10ubuntu2_amd64.deb) ... Unpacking replacement libmysqlclient12-dev ... Preparing to replace mysql-client 5.0.22-0ubuntu6.06.2 (using .../mysql-client_5.0.22-0ubuntu6.06.2_all.deb) ... Unpacking replacement mysql-client ... Preparing to replace mysql-server 5.0.22-0ubuntu6.06.2 (using .../mysql-server_5.0.22-0ubuntu6.06.2_all.deb) ... Unpacking replacement mysql-server ... Setting up libmysqlclient12-dev (4.0.24-10ubuntu2) ... Setting up mysql-client (5.0.22-0ubuntu6.06.2) ... Setting up mysql-server (5.0.22-0ubuntu6.06.2) ... $ sudo /etc/init.d/mysql restart Stopping MySQL database server: mysqld...failed. /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)' Killing MySQL database server by signal: mysqld. Starting MySQL database server: mysqld. /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)' satimis@ubuntu:~$ /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)' Please advise which file I have to edit getting the problem fixed. TIA
Mysql Server Not Starting
I installed mysql on a Mac OSX 1.3.9. It worked and ran with no problems. The machine was restarted and mysql will no longer start up. I have tried everything and nothing works. If I look at the logs it basically tells me that mysql starts and then shuts itself off.
Starting Mysql With Mysqld
i'm trying to change the mysql data path. to do this, i have to shoot down mysql and restart it. i tryed to restart mysql with the program mysqld (i'm using windows xp, mysql server 5.0), but it doesn't work. why? is there any different way to start mysql? there was no error message or something like this. if i start it with mysqld --standalone, it works, but the command window doesn't replay anymore.
Starting Mysql Server
I installed mysql with apache but after a while mysql stoped starting. I even reinstalled both mysql and apache but still i can not start mysql. could any one tell me how to fix this problem.
MySQL Slow Starting Up
I am using a Windows 2003 Web Edition Server running IIS and MySQL 4.1. I had to restart the server the other day and it took MySQL almost 2 hours to come back up. I was watching it on my task manager and it went up to approximately 60,000k in 10k increments before I was able to access MySQL. My CPU usage was hovering around 3% all this time. Everything else came up on the server just fine. This happens every time I have to restart my server. The reason I have to restart my server most of the time, is because MySQL locks up on me. Is there any settings I can change that would help me here? Any help would be greatly appreciated. One more thing to add. I am using the default my.ini file. We have almost 100 different databases on the server and have around 20000 tables within all of these databases combined. All of these tables are InnoDB tables.
Starting MySQL Initially
I am just starting to work with MySQL and I have it installed on a separae PC at my home as well. I downloaded and installed it, MySQL Administrator and the query analyzer as well. But I need to know how to create an initial database or does mysql come with a default database? I am asking because I tried to get in throughthe MySQL Administrator and it prompted for a database name initially that it can be linked to, but I realized there were no databases created. How can I create an initial database or is there some sort of utility window that comes with the MySQL download that I can access the database with? BTW, this is installed on Windows OS.
How To Prevent INSERT On Duplicate Rows With 30 Fields
I have a MySQL table with about 30 fields. I am inserting new data, and want to be sure that there are no duplicate rows. A duplicate row would be one with ALL the 30 fields (except the auto-increment index) exactly the same. How do I do that efficiently?
Starting Fresh With Mysql >> Dadabik
I have an Excel spreadsheet which has been my source document for the past several years for a collection I own. It has about 2000 entries (records) and each record has ~20 fields. Photographs of each item in the database are an integral part of this. What I'd like to do is move all of this knowledge onto the web in database fashion and provide a means to allow users to search the database. I found DaDaBIK which seems to be perfect for the show and tell phase of my project, but I need to create the database properly first. I can make a mysql database with my hosting account, but I don't know where to start. I know databases can be tricky; at least what I know of Access is tricky, so I want to do this right. I'm looking for help, maybe a simple tutorial, that will guide me through the process of transforming my Excel data and photos into a mysql database online. I have googled for this, but there are so many articles, and it is all over my head anyway.
Starting MySQL 5.0.1 Server Up Problem...
I shutdown my MySQL server using MySQL Administrator 1.0. My problem is that i dont know how to start up the MySQL Server again. I tried to run mysqld-nt.exe by double clicking it but my server will not be up. If i restart my computer then thats the time my MySQL server will be up. Unlike MySQL 4.0.22 if i double click on winmysqladmin.exe my server will be up. Is there a way to put the server up without restarting my computer?
Mysql Not Starting After VPS Server Reboot
I have a mysql db (Version: '4.0.22' FreeBSD port: mysql-server-4.0.22) running on an Verio VPS, and I am having an issue: After a power failure on Verio that meant restarted servers, etc, I saw that Mysql was not coming up. I checked the logs / etc and I got this message on /var/db/mysql/<hostname>.err: 060925 00:15:53 mysqld started 060925 0:15:53 bdb: Recovery function for LSN 1 29049 failed 060925 0:15:53 bdb: warning: ./testperl/testab.db: No such file or directory mysqld in free(): warning: chunk is already free 060925 0:15:53 Can't init databases 060925 0:15:53 Aborting There is no ./testperl/testab.db anywhere I can see, but OTOH, there should only be a few dbs and none of them is called testperl... Honestly, I have no idea of what might be hapening, but having the db is quite a PITA.
Problem Starting MySql From Root
I am in the process of creating a database which will serve as a backend for the registration of users' details and to handle account activation via the use of php scripts. I really need help with starting MySql. I have scoured various forums and followed instructions from the mysql.com, and other such tutorials. I am creating the website using dreamweaver on a windows 2000 pc but I am planning to place it on the linux box where the apache web server will handle it (if you know what I mean). The linux server is where the php and Mysql are installed. Incidentally the php installation is located in the /etc directory - and it works. I downloaded the Mysql binary file version 4.0.25 recently. Followed the installation instructions to the letter up to the change of ownership stuff. Code:
Newb Starting MySql-Permissions
I have debian running and this is how I have it setup # ls -ld /var/lib/mysql drwxr-xr-x 4 mysql mysql 4096 Aug 19 11:29 /var/lib/mysql I was shown how to setup a password for user mysql here http://dle.ascendant.ca/restoring-mysql-root-HOWTO.txt, because at one time all I would have to do it hit enter after # mysql -h localhost -p -u mysql Enter password: (no password is added I just hit enter) Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 16 to server version: 4.0.14-log Type 'help;' or 'h' for help. Type 'c' to clear the buffer. mysql> ( can do whatever I want now???) If I type in the correct password it lets me in, if I type in no passowrd it lets me in, if I type in the INCORRECT password it does NOT let me in. How can I make it so that if no password is typed it still treats it as incorrect?
Mysql Nt Service Stopped Starting After 2 Years
i have been running mysql on windows server 2003 for the last almost 2 years (its a really early version of mysql 4 anyway) but now all of a sudden mysql service stopped starting, i can go to services, press start and then refresh and its off again! i have a feeling that someone deleted the core mysql table (mysql) as it is now totally empty. im not too good with my sql as i generally use mssql or whatever, infact mysql never really installed properly, the only user i could ever use was root but i didnt mind this so i just left it and it was fine for 2 years but now its just stopped all of a sudden and i cant get it back on. i have enabled the mssql php exension as a backup system but i cant transfer any databases across without enabling mysql.. but it wont turn on! i tried several exes in e:mysqlin but none got it on (well one of them made the little winmysqladmin light go on for half a second)
Starting Mysql As Root User On Linux
I have created a user called mysql to administer the mysql installation. I can run mysqld_safe as the mysql user without any problems, however, when I try to run it as the root user with --user=mysql the process does not start and the following error message appears in the error log. 040706 17:03:06 mysqld started Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists! 040706 17:03:06 Aborting The user does exist, does anyone have any ideas what I am doing wrong?
Startup
I have just installed "fedora core 3" with taking everthing that come with it. Now I want to use the "mysql database",but when I run "mysql" command it says "check that database is running". and also "/var/lib/mysql/mysql.sock not found. 1. How to check that database is running or not? 2.How to create mysql.sock file. i have not installed any network card at all.I am workinf on the same pc in which I have installed the "fedora core 3".
Mysql_4.0.20 Startup
I have compiled (sparc solaris 9 box) and installed mysql 4.0.20 and face the following error. I have copied the startup script to /etc/init.d/mysql and linked it to /etc/rc3.d/S99mysql (as indicated in the sample file). When the system boots mysql doesn't start automaticallyb (rights are OK). Going through the error logs i found that it can't locate the libstdc++..... library which is under /opt/sfw/lib. When I run /etc/rc3.d/S99mysql start after I have logged in as root, mysql starts. Note that the LD_LIBRARY_PATH is setup and the path to the library is included.
Mysqld Startup
I'm using ssh to administer a mysql server, version 3.23.49, which I just installed. The problem when starting mysqld: I type "mysqld" at the shell prompt and hit return, then I get the message "mysqld: ready for connections". But then it doesn't give me back the shell prompt. I can type stuff on the screen, but it doesn't do anything. I've tried Ctrl-C and Ctrl-Z, but that does nothing. Any ideas?
|
TRACKER
