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 Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Linux Installing Connector/j
im using linux a few months ago, im working in a proyect using java stand alone and mysql, but i have a poblem i cant install Connector/J im using SUSE 10.0, if any person can help me installing Connector/J on linux, the readme file tells how install it in classpath but dont understand this is the example of the readme file: $ setenv CLASSPATH /to/directory of the Connector/J jar file..............:$CLASSPATH and my linux doesnt reconizaze "setenv" i dont know whats setenv, i dont know whats CLASSPATH,and i try whit: $ java -classpath /directory of the Connector/J jar file.......... and $ java -classpath /directory of the Connector/J jar file..........:$CLASSPATH
Installing MySQL
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
Help Installing Mysql
Ok, I'm new to this. My host has Mysql and Php already installed. I'm trying to install and configure the Mysql client in my computer to connect and work with the server. I'm using 4.1.21 as is the one that my host is using. What I do is to install the whole Mysql server in my computer and go through the configuration. Everything is ok, but when I open Mysql Command Line Client it prompts me for the password, I enter it and it introduces itself and leaves me with the Mysql command prompt: msql> I want to connect to my Mysql server and be able to enter the hostname and username of my server. Do I have to install the whole Mysql server in my computer or only the client program? How can I connect to my server? What do I have to do? Thanx for the help
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.
Help Installing Mysql
I am following the tutorial that walks you throught the steps of how to install mysql and php. I have installed both and I am now at the step of : To set a root password for MySQL, open a command prompt (or Terminal window) and type the following command in the bin directory of your MySQL installation: mysql -u root mysql Once I enter this into the terminal window, it says that there is no such command. I am running OSX 10.4.7 I have made sure that mysql server is running. Can you tell me what my problem is?
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
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.
Installing MySql On AIX Box
I am running AIX 5.1 on an RS6000 for a company wide custom application and database. I need to insall apache and mysql for an intranet on the same box. Any advice before I start? Anything I should be cautious about?
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?
Installing MySQL V4.0.14b
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).
Installing MySql 5.0
I am new to the world of SQL and would like some help regarding the start at the DOS prompt I have done a basic install but when I type mysql at the DOS prompt I get a "You do not have permission error ..., cannot logon as local host" The SQL server is on the same machine as the installation and I would simply like an anonymous log in.
Installing MySQL V4.0.14b
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).
Installing MySQL
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?
Installing MySQL
I am going to start work on a project using PHP/MySQL, and I was wondering if anyone could point me in the right direction on installing MySQL. I know where the website is and all, but I would appreciate if someone would just run through the steps for me.
Installing MYSQL 5.0
I have downloaded MYSQL 5.0 and unzipped it. but i need to know after unzipping which file i need to run to install it on my machine.?
Installing MySQL
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
Installing Mysql
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.why I may be getting this error.
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?
Installing MySQL 5
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?
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
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 ...?
Installing MySQL
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
Installing MySQL
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.
Installing MySQL
I am just installing mySQL on my laptop. I am just setting the root password. I have already set my password to twinsister: C:mysqlin>mysqladmin -u root passsword twinsister This worked fine. Now I am trying to set the hostname, and I have read in a thread on the net, that you should always set this to localhost, so I have typed this: C:mysqlin>mysqladmin -u root -h localhost password twinsister However, this is the error message I get: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' This is probably very simple to solve, but I just can't think what I am doing wrong.
Installing MySQL
This question will most likely seem unintelligent to you, but here's the basics: I'm doing web design for an organization, I want a mysql database on their server, I have access to this server via ftp, I know the server is Apache... How on earth do I install mysql on this server so I can start designing a database?? I've tried desperately to find a simple solution, but every resource I find is too complex... can anyone explain in simple terms, or perhaps point to a very beginner tutorial on how to get started? Can I even do this myself, or do the people who run the server have to install one for me? I'd much rather do it myself
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
Installing MySQL Twice
I posted a message yesterday asking how I could install a database on a separate volume than the default. Here's the thread. It explains why I need to do this: http://www.tek-tips.com/viewthread.cfm?qid=1403489&page=1 Another possible solution to my problem would be to install a second instance of MySQL on the new partition. But I would need to run both instances at the same time on the same OS. Is this even possible? Is there a better way to accomplish this task than what I have proposed in these two threads? “If you are irritated by every rub, how will you be polished?” ~ Mevlana Rumi Do you live in Michigan? Join us in the Tek-Tips in Michigan forum.
Installing MySQL 5
I installed MySQL 5 (free version) and at the end, it could'nt start the service, and I got the message: Cannot create Windows service for MySQL. Error: 0
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.
Installing Mysql
i typed into the command line "binmysqld --console"...my firewall alerted me that it was trying to access a DNS...i clicked 'block this action', and then the command line shot me an error: can't start server: Bind on TCP/IP port: No error 050306 [error] Do you already have another mysqld server running on port3306? 050306 [error] Aborting 050306 [note] binmysqld: Shutdown complete and that's where i am. now when i run it again, there is no prompt and it just gives me the error.
Installing Mysql
I need help installing a classified database on my server please!! I have most of it done, db created, I am just missing something somewhere.I am at ncentity at gmail.com I can afford to pay someone 15 dollars via paypal for a few minutes of their time.
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....
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.
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...
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?
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?
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
Help With Installing Mysql On FreeBSD
I am newbie, trying to install Mysql 4.0 on FreeBSD 4.7 platform. I downloaded the standard version went through the instructions for no avail. scripts/mysql_install_db chown –R root . chown –R mysql data chgrp –R mysql . bin/mysqld_safe –user=mysql & But still mysql is not up and running
How To Go About Re-installing MySQL On A New Machine?
I have MySQL installed and a database already built and loaded with data that is collected nightly from the mainframe database. I am currently running on NT and will be loading a new image onto the machines to change the operating system to Windows2000.From what I understand, I will need to copy all files I want to keep, including my database. My question is, once the new image is on, I will need to re-install MySQL, is it as easy as just copying back the MySQL directory back onto the machine and the database still work?If not, can someone tell me what the general process is to do this without losing the database and any issues that I am going to run into?
Installing And Configuring MySQL
System: MAC 10.3.2 G4 workstation For the past three weeks I am trying to do the "simple" install. But of course it never works the way it reads. I have followed the FAQ and install descriptions that came with the package <http://www.mysql.com/doc/en/Mac_OS_X_installation.html> but i am stuck. At the moment I need to create a database and set the root password. i have no idea why it is not working. the following is the command line and error I am getting. Can someone please help me to install this properly?
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?
Installing MySQL With Apache?
I have mySQL installed on my machine as well as Apache. However, i haven't done any configuration of the httpd.conf file to tell apache anything about mySQL like i did with PERL. do i need to do any configuration before i can interact with mySQL through apache? or can i just have at it?
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)
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?
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.
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
|