Installing MySQL On Mac OS X
I have just purchased the sitepoint book, "Build your own database driven website using php and mysql". I'm obviously new to this and I went to the start of the Mac OS X installing mysql. I have downloaded MySQL and installed it. It then tells me to open up the terminal window and type in the command:
shell%sudo /usr/local/mysql/bin/mysqld_safe
It then tells me to make a file my.cnf and put it in the file:
/usr/local/mysql/data/
When I do a search for this folder I get the result "The folder cannot be found".
I have tried going back to the terminal and entering the above code again but it says "A mysql process already exists".
This is how the terminal displays when I have typed it all in:
Welcome to Darwin!
Darrens-Computer:~ Darren$ sudo /usr/local/mysql/bin/mysqld_safe
Password:
A mysqld process already exists
View Complete Forum Thread with Replies
Related Forum Messages:
Installing MYSql 4.0.12
I have downloaded MySql-standard-4.0.12 FOR MAC from the MySql website. I have installed it on Mac OS X 10.1.3. When i am starting the MySql, it starts and ends with the message "030821 <time> MySqld ended". Does anyone know what the problem is ...?
View Replies !
Installing MySQL On Mac OS X....
Just in case anyone has the same problem. After a few hours, I found the solution for installing MySQL on Mac OS X. As well as a ton of other people, I was getting the error... Can't connect to local MySQL server through socket '/tmp/mysql.sock' Its a problem with permissions. Try this from the terminal, it worked for me... sudo chmod 1777 /tmp and sudo chown -R mysql:mysql /usr/local/mysql/data
View Replies !
Installing Mysql On Rh9
im having a nightmare tryng to get mysql to work on rh9. ive tried v4.1 and that didnt work so ive gone to v3.23.49-1 i386. Anyway ive looked around and downloaded a tutorial and done exactly what they have done in the tutorial, but i get an error when i run isql it says Quote: Could not SQLConnect Ive set the directories of the driver & setup file in the odbcinst.ini as he did in the tutorial
View Replies !
Mysql Installing
now i need to download mysql.can anybody tell me which version of mysql is supported for my platform?also mysql server and client i knew.apart from that, what are the mirrors i need to download? also tell me how to install it and where to install ( means the location . is it in /usr/local or something else).actually am going to work with perl and mysql.hence ,i need this mysql to be installed in the system.
View Replies !
Installing MySQL 5.1 On Mac OS X 10.5.6
The data directory had already been created on my machine, so I assumed that step 2 of the post-install process was not needed. Step three (bin/mysqld_safe --user=mysql &) failed with the following error: [1] 400 anuraag-tiwaris-macbook-pro:mysql anuraagt$ 090312 01:08:01 mysqld_safe Logging to '/usr/local/mysql/data/anuraag-tiwaris-macbook-pro.local.err'. touch: /usr/local/mysql/data/anuraag-tiwaris-macbook-pro.local.err: Permission denied chown: /usr/local/mysql/data/anuraag-tiwaris-macbook-pro.local.err: Permission denied 090312 01:08:01 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data bin/mysqld_safe: line 96: /usr/local/mysql/data/anuraag-tiwaris-macbook-pro.local.err: Permission denied rm: /usr/local/mysql/data/anuraag-tiwaris-macbook-pro.local.pid: Permission denied bin/mysqld_safe: line 133: /usr/local/mysql/data/anuraag-tiwaris-macbook-pro.local.err: Permission denied 090312 01:08:01 mysqld_safe mysqld from pid file /usr/local/mysql/data/anuraag-tiwaris-macbook-pro.local.pid ended bin/mysqld_safe: line 96: /usr/local/mysql/data/anuraag-tiwaris-macbook-pro.local.err: Permission denied
View Replies !
After Installing MySQL
I finished installing mysql, windows 4.1 essentials, on my machine. I have a fully functional Apache client with PHP, CGI, ASP, etc. ready to go on it. I want to know if there is anything else I need to do, because I'm _new_ at this... What should I put in httpd.conf to get mysql working? Do I need any other programs?
View Replies !
Installing MySQL From RPM
I am very new to DB installations. But either way I am in charge of setting up MYSQL on our server. Here is what I know. I downloaded MySQL-server-community -5.0.51a-0.rhel3.ia64.rpm i used SSH to put the file on my root now I am using PUTTY to load. but I am completely lost from here. Is there any set directions to install?
View Replies !
Installing MySQL 4 Or 5
I've got a G4 that runs OS X 10.2.8 and Apache 1.3 I've been trying to install MySQL for a couple days now. I run the installer and it says Installation successful then I install the pref pane, restart the G4 but when I select the MySQL preferences and try to start the server nothing happens. I've tried shutting down any other MySQLs with the Terminal but that comes back with "command not found" I can't find any new MySQL folders either. Any suggestions?
View Replies !
Installing MySQL 5.0.27 On OS X 10.4.8
I'm on page number 29 in "Build Your Own Ruby on Rails Web Application" where Patrick is instructing us on how to install mySQL. I've downloaded the current stable release of mySQL, run the mysql-standard-5.0.27-osx10.4-powerpc.pkg and was told that the installation was successful. Here is my concern: I remember many months ago when I was fooling around with PHP and I recall installing multiple versions of PHP and mySQL on my machine. I remember specifically using Marc Liyanage's packages available on www.entropy.ch as well as MAMP. Now, when I execute the following commands as per Patrick's instructions, I receive errors. From the book: Quote: Excellent. Next, we need to start the server—we’ll do this manually for now. Open a Terminal window and enter the following command: $ sudo /usr/local/bin/mysqld_safe5 This is returned: Password: sudo: /usr/local/bin/mysqld_safe5: command not found mason:~ Mason$ Included in my mysql-standard-5.0.27-osx10.4-powerpc.dmg file is a ReadMe.txt, which provides a different command for connecting to the mySQL server. That is: $ sudo /Library/StartupItems/MySQLCOM/MySQLCOM start Which after entering that, I receive: Starting MySQL database server And yay, the server appears to have been started! Once MySQL is running, you can tell it to run in the background by hitting Ctrl- Z, then entering this command: $ bg When I press Control-Z and enter 'bg', the message returned to me is: -bash: bg: current: no such job Hmm. Does that mean mySQL really isn't running? Also, what does pressing Control-Z do? Anything special? How do I know that whatever it's supposed to do is actually being done? Should something indicate that it's been pressed? Not knowing what to do, I proceed with his further instructions to: Quote: ...close the Terminal window; MySQL will continue to run as a server on your system. Now, all that’s left to do is confirm that the MySQL server is indeed running as expected. In your Terminal window, type the following: $ ps -ax | grep mysql This command should return a few processes that relate to MySQL. Running that command returns this: 4903 p1- S 0:00.04 /bin/sh ./bin/mysqld_safe --datadir=/usr/local/mysql/ 4922 p1- S 0:05.15 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysq 7260 p1 R+ 0:00.00 grep mysql Since I'm new to all of this, I can't tell if that's good or bad or if that means mySQL is actually running or it isn't. It does at least appear to show the processes that are running, like he said. Does anyone know if mySQL is actually running though? He goes on to say: Quote: If it does, you can try to connect to your database with the following command: $ mysql5 This should present you with a mysql> prompt I figure, since it does return some processes, like he said it would, it's ok to try that command out. But, oh noes! This is what happens when I do: -bash: mysql5: command not found So, just out of curiosity, I decide to look in /usr/local/bin/ where apparently this thing belongs, but it isn't there! So now I'm at an impasse. I have to wonder, could my previous installations of mySQL be conflicting somehow with my recent one? Why isn't mysql5 in /usr/local/bin/ and why am I not being presented with a mysql prompt when I enter mysql5 into the command line? I'm not sure if I should proceed in the book without first working this out as I question whether or not leaving it unresolved could create more problems and confusion for me down the line.
View Replies !
Help Please: Installing MySQL Etc.
I'm trying to install MySQL and PHP onto my machine (A Mac with OS X 10.4). I think I've done it but I'm not sure. And I haven't been able to setup a root password. I'm working through the "Database Driven Websites" book. I've done eveything but then I get stuck on this next bit which I think is to set a root password. It says to type in "mysql -u root mysql" into my terminal but when I do it just says "-bash: mysql: command not found". I don't know if its to do with not being in the bin directory? But I don't know how to do this. I'm very new to this all.
View Replies !
Installing MySQL RPM On Linux
I am trying to install MySQL with this command: rpm -ivh MySQL-server-4.0.13-0.i386.rpm I get bunch of errors regarding conflicts with the existing installation (files in /usr/share/mysql/.....) 1. Originaly mySQL was isntalled with Linux 7 install 2. I can't un-install mySQL via Linux Add/Remove program, I get an error stating sthat shared library option must be selected (it's is selected) 3. I have deleted /usr/share/mysql directly, but still have a problem.
View Replies !
Problem Installing Mysql 4.0.14
I have tried to install mysql 4.0.14 and previous version on my machine. After installation when I try to run mysql, i get error: "Cannot connect to localhost port..." my machine is not connected to internet. I also have firewall installed on my machine, but this should not matter.
View Replies !
Installing MySQL V4.0.14b For Windows
I have just downloaded MySQLv4.0.14b for windows and 21% through the installation, it displays the following error: An error occurred during the move dataq process: -132 Component: File Group: File: The MD5 hash matches the one on your website and I have spent another 5 hours or so downloading it again from your main site instead of a mirror site, but it stills does the same thing. I'm installing it into the the same folder as the previous version (3.23.49).
View Replies !
Solution For Installing MySQL On Mac OS X
Just in case anyone has the same problem. After a few hours, I found the solution for installing MySQL on Mac OS X. As well as a ton of other people, I was getting the error... Can't connect to local MySQL server through socket '/tmp/mysql.sock' Its a problem with permissions. Try this from the terminal, it worked for me... sudo chmod 1777 /tmp and sudo chown -R mysql:mysql /usr/local/mysql/data
View Replies !
Error In Installing MySQL
I have the following errorw while i try to execute the MySQL-Front. Any one can tell me about the problem ? As i have no errors at all before i format my computer, i use the same version of MySQL and MySQL-Front.Thanks. =========================================== Connection failed 1251 - Client does not support authentication protocol requested by server; considering ugrading MySQL Client. ===========================================
View Replies !
Installing Local MYSql
I want to install mysql on my local machine so I can test scripts and run code. Does anyone know which package I need to use and how to do this?
View Replies !
Installing MySQL For Study
I want to install MySql on my computer, so that I can use it for studying. I want to create tables and run queries from my computer. CurrentlyI have installed mySql and all its components,but I dont know how to customise it to my needs.Can any one help? Or is there any other sql interpreter so that I can use it to build tables and queries for educational purpose.
View Replies !
Successful Installing Mysql 4
IThe problem is talking about "Error: Driver 3.51 Not found" when opening winMySQLAdmin. The problem still exists after installing myODBC and making other configurations anyway. But when I notice the download section in mysql.com, it states the windows installer unzip in C: . So, mysql should be installed in C: but not other driver because I have tested that mysql does not run when installing in other drive but does when installing in C:
View Replies !
Installing Mysql Messaging Api
I have been trying to install the message api ( http://messagequeue.lenoxway.net/ ) , I have installed the underlying spread api and have installed the spread api. But when i try to create the functions using the C library i am getting the following error ERROR 1126 (HY000): Can't open shared library 'message_api.so' I am using mysql version 5.0.18 installed Linux ES release 4 and have installed the api also in the same linux version
View Replies !
Installing Mysql-administrator
(This is also posted in the install forum) For some reason I can't get the rpm to install so I tried using the tarball and when I do this, the /opt/mysql-administrator-1.0.19/bin directory does not get created. Command I used to install mysql-administrator: shell> tar --directory=/opt -xzvf mysql-administrator-1.0.19.tar.gz Does anyone have any suggestions or another way to install this application on Linux? ...or am I missing a step? The rpm is preferred, but anything that works would be great.
View Replies !
Installing MySQL On A Server
Im setting up a remote testing server, I have installed Microsoft Windows 2000 Professional on it, I have also installed MySQL on it, However when I try to connect to the MySQL server using MySQL Control Center I get this error message: [Production Server] ERROR 1130: Host '192.168.1.101' is not allowed to connect to this MySQL server Can someone help please, Is it because I have to install a server operating system for this to allow remote clients? (I.e. Windows 2000 Server), I have not firewall enable by the the way.
View Replies !
Installing MySQL 5.0.24 On Leopard
I'm trying to install MySQL 5.0.24 on Leopard. I've downloaded the package - version Mac OS X 10.4 (x86): http://dev.mysql.com/downloads/mysql/5.0.html#macosx-dmg - and installed it with the wizard. The installation was successful, but the directory /usr/local was not created. The reference manual (http://dev.mysql.com/doc/refman/5.0/en/mac-os-x-installation.html): "The Mac OS X PKG of MySQL installs itself into /usr/local/mysql-VERSION and also installs a symbolic link, /usr/local/mysql, that points to the new location." What am I doing wrong?
View Replies !
Installing PHP/MYSQL On A Win Network
I am going to teach PHP/MYSQL to a group of students on a windows network. Do I have to install these on every station or only on the server? In which directory do the students save and test their work?
View Replies !
Installing MySQL And PHPMyAdmin
I have installed Apache, perl and PHP to my windoze Me pc. I want to build a MySQL Db and ask you to point me to a good step by step install for both MySQL and PHPMyAdmin. Don't I need PHP MyAdmin to build Db's for MySQL?
View Replies !
Installing MySQL Server
I'm having trouble installing MySQL server on a Windows XP SP2 computer. But I get the following error when I'm nearing the end of the installation The security settings could not be applied. Error Number 2003. Can't connect to MySQL server on 'localhost'(10061)
View Replies !
Installing MySQL To XPPro
. I read the stickies and searched the MySQL forum but couldn't find an answer to my problems. Hope you can advise me. I also read the Community Guidelines, being a newbie, and had a little chuckle in the Republishing Your Words section where it says "how things work in the real word". I'm a new web designer/developer on a course which will include ASP.Net and Access, but I'm also reading Kevin Yank's book "Build Your Own Database Driven Website using PHP & MySQL" (3rd Ed) to learn PHP & MySQL as well. I have 2 probs so far with the installation instructions in Chapter 1: 1) Installing PHP (pg 5,6 in the book) I installed PHP 5.1 into C:Program FilesPHP, copied php5ts.dll & libmysql.dll from the PHP folder to system32 and copied php.ini-dist to Windows folder, renaming it php.ini. Edited this and changed the extension_dir to point to "C:Program FilesPHPext". But I don't have an ext folder in PHP! In fact I don't have any subfolders in PHP. Is this crucial? Should it just point to "C:Program FilesPHP" instead? 2) Assigning a root password for MySQL (pg 21,22 in the book) At the command prompt, I type: mysql -u root mysql and I get the mysql > prompt. When I type the command: UPDATE mysql.user SET password=PASSWORD(new password) -> WHERE User="root"; replacing 'new password' with my password, I get the following error: Error 1064 (42000): You have an error in your SQL syntax; check the manual ... for the right syntax to use near '> WHERE User="root"' at line 1. In the book the text wraps at the '->' so the syntax might be wrong here, but isn't this like the DOS redirect symbol? I keep looking at the rest of the syntax but haven't spotted a difference between the typed command and the book yet. Any suggestions as to what the syntax error might be? In the book, the commands after this are: 'FLUSH PRIVILEGES;' and 'quit'. Are commands case-sensitive? In the book, '(new password)' is actually written '(*new password*)', but I removed the asterisks in response to an earlier error message.
View Replies !
Installing MySQL With InstaGate EX
I have always just had MySQL on servers I have dealt with, so I've logged into the web host control panel and have been able to add users and databases from there, either on the hosts control panel or by PHPMyAdmin. On the particular server I am working with, the server is housed on the premises. So they don't really have a control panel all they have given me are the details for InstaGate EX... Any ideas how I can use this to: a) See if MySQL is on the system b) Add databases to it
View Replies !
Trouble Installing MySQL On Mac OS 10.4
I'm working on a Mac under OS 10.4 In the hopes of making my website interactive I've been trying to use Kevin Yank's book "Build Your Own Database Driven Website Using PHP and MySQL" to learn some MySQL and some PHP. (At the moment I know only a tiny bit about PHP and nothing about MySQL.) Despite my determination to go about this in a calm and orderly way, I've run into a frustrating obstacle right at the beginning. To make matters worse, I'm not even sure what the problem is, which makes it difficult to ask for help. I don't know whether MySQL is actually installed and I just don't know how to use it or whether, despite my efforts, it's not really installed at all. I tried to install it according to Kevin's instructions and thought it had been installed properly (I mounted the dmg and a "startup package appeared in my Library, but when I tried to proceed farther by typing commands into a Terminal window according to Kevin's instructions, I just got a "command not found" response.) I read what Apple has to say about installing MySQL under OS 10.4 and tried again, but when, following their instructions to make sure no MySQL processes were already running before installing I entered "mysqlshutdown admin" once again I got a "command not found". One other thing: I think the problem (or part of the problem) might be that I'm not in the right directory when I type in these commands. I get the impression MySQL stuff is supposed to be happening in the "root" directory, but when I type in "cd root" in the Terminal window I just get another "command not found." (Before I started to work on this yesterday I'd never used a Unix terminal window!) I'm a bit embarrassed and hesitant about this post — my first on this forum— because I'm afraid it's going to sound very ignorant and confused. But you do say beginners are welcome so....
View Replies !
Installing MySQL Client
I'm sure this is a really noob thing to be asking.... I have MySQL and PHP installed onto my web hosting server and it's running fine. Now, my problem is that I can't figure out how to access it from my computer. I'm mainly using Frontpage (because that's the program that everything was built on before I was hired) to build the websites. What is the easiest way to be able to start using this database?
View Replies !
Problem Installing MySQL And.....
I tried to install PHP and MySQL on my PC which runs on Vista premium. But could not install. Half the way it gives error message of port no 3306 or somethin.. Is vista an issue or am I doing something wrong... I am trying to make my PC local server, Apache but issues with that too...
View Replies !
Problem Installing MySQL
Hope this is the right forum to ask this in. I am attempting to do the install from Kevin Yanks book (3rd ed) on Fedora 6 with Apache 2.2.6 and MySQL 5.0.45 and having problems getting MySQL to run. First I installed Apache using bluemarkup.com for a domain name. Then I installed MySQL. MySQL seems to install but when I go to test the install it fails. Using the mysql-test-run.pl utility in /mysql-test/ I get an error message that says "can't find IP number for localhost". Using the startup procedure from Kevins book yields a less clear "STOPPING server from pid file /var/run/mysqld/mysqld.pid mysqld ended done" Where does MySQL obtain the IP address of the localhost from? Do I need to add an ip address to a mysql configuration file, or add an IP address in iptables? Also - the name of my server is not localhost - it is bluemarkup.com. I would expect MySQL to use that domain by default. Is there someplace that I need to configure this?
View Replies !
Problem On Installing MySQL
Ubuntu 7.04 server amd64 MySQL 5.0.38 On installing MySQL and coming to; $ sudo mysqladmin -h ubuntu.xyz.com root password myrootsqlpassword mysqladmin: connect to server at 'ubuntu.satimis.com' failed error: 'Lost connection to MySQL server at 'reading initial communication packet', system error: 111' $ hostname -f ubuntu.xyz.com $ ps aux | grep mysql root 4557 0.0 0.0 3860 572 ? S 20:35 0:00 /bin/sh /usr/bin/mysqld_safe mysql 4599 0.0 1.0 160556 21992 ? Sl 20:35 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock root 4600 0.0 0.0 3768 576 ? S 20:35 0:00 logger -p daemon.err -t mysqld_safe -i -t mysqld satimis 5133 0.0 0.0 5028 828 pts/1 S+ 21:15 0:00 grep mysql $ cat /var/log/daemon.log | grep 111 No printout $ cat /var/log/messages | grep 111 Oct 23 08:54:28 ubuntu kernel: [ 24.857900] ata2.00: ATA-7: Maxtor 6V160E0, VA111900, max UDMA/133 Oct 23 08:54:28 ubuntu kernel: [ 33.667111] i2c_adapter i2c-1: nForce2 SMBus adapter at 0x1c40 Oct 23 09:50:31 ubuntu kernel: [ 23.021112] io scheduler cfq registered (default) Oct 23 09:50:31 ubuntu kernel: [ 25.185695] ata2.00: ATA-7: Maxtor 6V160E0, VA111900, max UDMA/133 Oct 23 09:50:31 ubuntu kernel: [ 27.717111] sd 1:0:0:0: Attached scsi disk sda Oct 23 09:50:31 ubuntu kernel: [ 33.805111] ACPI: PCI Interrupt Link [AAZA] enabled at IRQ 21 Oct 23 19:05:48 ubuntu kernel: [ 25.327627] ata2.00: ATA-7: Maxtor 6V160E0, VA111900, max UDMA/133 Oct 23 19:43:21 ubuntu kernel: [ 22.142111] ACPI: PCI Interrupt Link [LNK8] (IRQs 5 7 9 10 11 14 15) *0, disabled. Oct 23 19:43:21 ubuntu kernel: [ 25.058170] ata2.00: ATA-7: Maxtor 6V160E0, VA111900, max UDMA/133 Oct 23 19:43:21 ubuntu kernel: [ 33.379111] i2c_adapter i2c-0: nForce2 SMBus adapter at 0x1c00 Oct 23 20:35:27 ubuntu kernel: [ 24.573772] ata2.00: ATA-7: Maxtor 6V160E0, VA111900, max UDMA/133
View Replies !
Installing MySQL 5 On Linux
I have just been asked to install MySQL on a server which only has command line access. Despite having used MySQL on Linux for quite some time I have never carried out command-line installation before. The server is Redhat 9 and does not currently have any version of MySQL installed. Can anyone point me in the direction of a comprehensive installation guide which begins with post login via ssh which is where I can currently get to. ie..I need to know, how to download it AND how to then install it.
View Replies !
Installing Mysql-administrator On Redhat
I am unable to install mysql-administrator on Redhat AS 4. #rpm -i mysql-administrator-1.1.6-1.i386.rpm erreur: Dépendances requises: libstdc++.so.6(GLIBCXX_3.4.4) est nécessaire pour mysql-administrator-1.1.6-1.i386 But I already have the library: #ls -l /usr/lib/libstdc++.so.6 lrwxrwxrwx 1 root root 18 nov 16 17:27 /usr/lib/libstdc++.so.6 -> libstdc++.so.6.0.3 Anybody have had such installation problem?
View Replies !
Trouble Installing The MySQL GUI Tools With Red Hat 8.0
I just installed MySQL Community Server 5.0 onto my computer, which is running Red Hat 8.0 and it works fine, but I was trying to install the MySQL GUI Tools (Query Browser, MySQL Administration and the Migration Toolkit) and I'm having trouble with it, I have decompressed the installer , I go to the installation directory (/usr/local/mysql/mysql-gui- tools-5.0) and type in ./mysql-query-browser to run the query browser, but it gives me this error message: ../mysql-query-browser-bin: error while loading shared libraries: libgtkmm-2.4.so.1: cannot open shared object file: No such file or directory.
View Replies !
Installing Multiple MySQL Servers
If you need multiple MySQL servers running, what's the difference between installing MySQL once and running multiple servers (by issuing multiple mysqld commands with their own options), versus actually installing two or more DIFFERENT instances of the same version of MySQL? What is typically done? What are the advantages/disadvantages of either method?
View Replies !
Installing MySQL 5 Perl DBI Must Be Installed?
the steps to installing MySQL 5 on Red Hat Linux 9? When I follow the steps as outlined in the manual or Red Hat text I get an error that Perl DBI must be installed. After attempting to download the Perl DBI; that failed because the server was not availabe. Eventually I was able to download some Perl stuff, but not the DBI. Here is the problem at its root. Where is the information to handle all of the error messages? Where is the source of knowledge to work around these problems?
View Replies !
Problems Uninstalling And Re-installing Mysql 5.0.15 On Mac OS X
Brand new Mac user trying to install mysql 5.0.15 on local machine running Mac OS X version 10.4.3. After downloading and opening mysql-max-5.0.15 package, I get the following error: "You cannot continue. There is nothing to install." Tried unistalling mysql (to see if that was the problem) using directions from http://www.entropy.ch/software/macosx/mysql/remove-old-mysql.html -- however, after running the command "mysqldump -u root -p --all-databases > mysql-dump.sq", I get the following error: "mysql-dump.sq: Permission denied" Looking for basic step-by-step direction to completely unistall mysql, in order to try re-installing mysql again.
View Replies !
Installing Mysql As User, NOT Root
I've had to install mysql as a regular user, and not as root. Before it was so simple since I was root but now I am on someone else's server. I downloaded a non-RPM Standard5.0.19 binary. I untarred it and blindy tried to start it and of course got a number of errors. I found that mysql 4.1.12 was already running. I took a look at http://lists.mysql.org/mysql/42514 and decided to make some changes: - uid - TCP port - socket file - basedir - datadir In mysql.server (in support-files) I changed the basedir and datadir to (/apps/myaccount is my home acct) /apps/myaccount/base and /apps/myaccount/data, but as the above listed post mentioned, I also need to change 3 other things. I need to put everything into my home account, so how should I change the uid, the tcp port, and the socket file?
View Replies !
|
TRACKER
