Installing And Configuring MySQL

Configuring MySQL On Mac OS X
I recently tried to install MySQL on Mac OS X box using these instructions on the Mac site (http://developer.apple.com/internet/macosx/osdb.html). All was working fine until I got to this part here:

./configure --prefix=/usr/local/mysql --with-unix-socket-path=/usr/local/mysql/run/mysql_socket --with-mysqld-user=mysql --with-comment --with-debug

I got a bunch of "file not found" errors so I wanna trash whatever I did and start from scratch, but I don't know what exactly to delete? Does anyone have an idea about this?

---

Configuring MySQL
I have WindowsXP Proff. O/S. And I have installed mySQL ver 5.0.1
I have also installed php and Apache in it. Now I want to configure it
with Apache, PHP and I also want to configure with phpMyAdmin.
so I can use it comfortabley. So does anyone have an documentation
of it?

---

Configuring PHP And MySQL
I've installed Apache 2.0.59 [ C:Program FilesApache GroupApache2 ] and PHP 5.1.6 [C:PHP] successfully. I've tried test page also it works. I've also installed MySQL 5.0.24a successfully. But i couldn't connect PHP file with MySQL database. I've searched in google too but not getting please write for me or suggest me the best website which describe the installation process of the version i've mentioned above.

---

Configuring MYSQL 5.0
I downloaded MYSQL 5.0 and tried to configure it but I do get the message "Could not start service MYSQL : Error :0". if anyone can advice me what do or where to seek information to correct the problem.

---

Error Configuring Mysql?
I have installed MySQL CE 5.0, but during the configuration wizard I get an error.

It has frozen up during the final step (MySQL Server Instance
Configuration). I'm installing it on Windows XP, and I used all the
default settings, except that I changed "Detailed Configuration" to
"Standard Configuration". At the "Start Service" item in the checklist,
I got a 1045 error message saying to allow TCP port 3306. I tried
creating a rule for this in Norton, but it didn't seem to work.

So then I turned off Norton completely, restarted, tried the wizard, and
now it puts a red 'x' in the "Start service" checklist and says "The
service could not be stopped. Error: 0".

So I don't know if this is really a Norton/firewall issue or not. I
can't seem to get around this final step.

---

Configuring MySQL For JDBC ?
I'm having a MySQL DB running on one machine and a Java-Tool which accesses this DB via JDBC. With this tool, I can add a second DB data source in form of a mySQL DB and I've installed one more MySQL DB on a third machine, which runs perfect, but the access from the java-tool via JDBC-connection doesn't work.

Command line "mysql" tool work perfect from the machine where the java tool is running. The company which coded the java-tool told me that I have to install a package for the mysql db which enables jdbc. Is that right and what do I have to configure ?

---

Configuring/Setting Up MySQL 5
Im a complete newbie to mac os x. I downloaded and installed mySQL 5. I installed it and now i cant seem to connect. I have absolutely no idea what im doing. Im not familiar with os x termial commands. I need someone to email me and explain to me everything i need to do in order to create a user and successfully login using mySQL admin.

I've been struggling with this for over a week. Ready to pull my hair out. And please dont refer me to online resources, ive read them all and still cant figure it out. I need a professional who can give me a step by step process to get this going.

---

Configuring MySQL With Tomcat
I'm trying to configure Tomcat 4.0.1 with mySQL 1.3. I have copied the mySQL driver (mm.mysql-2.0.8-bin.jar) into tomcat/common/lib but I can't get a connection with the database. I can see the database and tables when I use the GUI for mySQL (winmysqladmin.exe). I'm running Win2K and java 2sdk1.4.1_06.

---

Configuring MYSQL Enterprise Monitor
I was given the setup files for configuring the MYSQL Enterprise Monitor with dashboard for testing in Local.

1. I have installed MYSQL Server to my localhost [Windows].
MYSQL SERVER Version: 5.0.50sp1a-enterprise-gpl-nt.

2. I have installed the MYSQL Network Monitor to my local system [Windows]
With all options like admin login, agent and other details.

But my doubt is how to set my MYSQL DB Server for regular monitoring using the MYSQL Enterprise Monitor.

I.e I just want to know about the Server setting like how to add my localhost server to the Mysql Enterprise Monitor.

We have a Enterprise Subscription but as iam just a developer i dont have the login id so can i get help from here?

---

Software Rollout: Configuring Mysql Driver
When rolling out software that uses a mysql backend, how is it possible to configure the odbc driver for mysql during the installation process of the software?

Is there anyway to do this via command line, installshield, batch files..? What would one do if individuals were not "computer literate", and would not how to go about setting up the driver themselves or to make it easier, the software would automatically do it for them?

---

Configuring MyODBC
I am using MyODBC 3.51 with Borland BDE, and was having a problem whereby Blob result fields were being restricted to a maximum size of 32k. Now, in the BDE control panel, I can set configuration variables for the MyODBC driver, and I was able to change the value of BLOB SIZE from 32 to 128, which solved the problem. However, there are many other configuration variables there (TRACE MODE, BATCH COUNT, BLOBS TO CACHE, ENABLE SCHEMA CACHE, ROWSET SIZE, etc.) for which I have not been able to find any documentation. Does anybody know where I can find documentation for these settings?

---

Configuring A New Server
while configuring a new server instance the following error message is throwed:

" The template configuration file cannot be found at C:programFilesMySQLMySQL Server 4.1inmy-templates.cnf "

---

Configuring On Win98
Win98 , Apache 2.0, Apache running on port 443 is that matters.
Latest version (community) of mysql, 5 i think.
Have run the msi file and installed mysql. Wasn't promted for a username / password during this , not sure if thats right, maybe only on win2000/xp?
I'm stuck as what to do next.
cd'ed to mysql....in and ran mysql.exe and gives me the error,
cant connect to mysql server on localhost 10061.

---

Configuring The Service In Each Start Up?
A couple of weeks ago I posted several questions in one post, and I think I overwhelmed people, so I'm breaking it into individual questions this time.

I don't know why but everytime I use MySQL I need to reconfigure the server using the wizard(I go to start>programs>mysql>MySQL server 4.1>MySQL service instance config wizard) everytime I turn my computer on. If I don't, I get a "ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)" error when trying to connect to the server in any account. I don't have to change anything when I run the wizard, I just click next all the way, and when its done I can connect normally.

I've noticed that at the end of the configuration when its running through all the tasks, the last one says "Sart service". I'm guessing that I'm not starting the mysql service when I turn my computer on, and that reconfiguring the service solves the problem because it starts the service for me. Do I have to reconfigure the service everytime I want to use it? Is there another way or maybe start the service automatically?

---

Configuring XAMPP In The Domain
I am installing my XAMPP in my pc.

It works fine. Everything works. My question is, is it possible to install XAMPP inside in my domain e.g., www.mydomain.com/xampp. Please help me to configure it using the domain, not in the localhost.

---

Configuring Database Server
tell me a way to increase the productivity of a database server. It has nothing else installed other than the newest production version of mysql and the default packages from FreeBSD.

Is there a toaster than can bring me up to speed.

---

Error Configuring PhpMyAdmin
I'm trying to install phpMyAdmin on a test server. I am using the GUI to create the configuration script.I would like to use HTTP mothod for authentication. As the guide says, I need to create a user and grant some privileges to the user. Here is the problem.
mysql -u root -p
INSERT INTO `user` (Host, User, Password) VALUES('localhost','pma',PASSWORD('something'));
Next I try to grant privileges, but receive an error:

GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY 'something';

Error 1133 (42000) Can't find any matching row in the user table.
Now I know the user is there...If I do

SELECT * FROM `user` WHERE User='pma';

I get results, 1 row in set. The password is encrypted, but I did double check with the original user creation line and it is the same and typed in correctly. localhost is also there.So why is it not finding any user when I want to grant privileges?

---

Configuring Script For Mbstring And Pconnect
i was told i need to "configure your script to use pconnect (persistent connections) to the mysql database.". because "Your site is creating too many concurrent connections (20 is a reasonable limit).".

as well i need to figure out how to add the mbstring function on mysql, so that my pages with special characters (french characters), will load up properly.

---

Configuring A Database On A Remote Server
i have an aplication on .net for web, with mysql db, in my local server i have no problems, but recently i upload the aplication into a bougt host; when i open the page on the internet explorer or firefox, the page loads well, except for one simple grid. in another part of the aplication i try to insert a record, the app gave the me no error message, but when i check the table, there's nothing new.

i don't if i configuring something wrone, on the web.config. and the worse of all if that i dont get any error?

---

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.

---