Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
 
  HOME    TRACKER    MYSQL




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 Complete Forum Thread with Replies

See Related Forum Messages: Follow the Links Below to View Complete Thread
Deleted Root User From Mysql.user !!!
While trying to grant access to root user, i deleted all entries for root from mysql.user.

I've tried to use root% (anonimous built-in administrator user) but to no good).

Is there another admin user i could use to run mysql monitor and insert root records to mysql.user? I've read

Could I use a copy of the mysql.user table?

I'm using version 5.0.16-standard on Linux Fedora Core 3.

Before ruinin the root user, i made a backup of a databasefrom the same server (not mysql database); i was wondering if that backup contains the mysql.user information somehow?

How Do You Log In As Root User On A Mac In Mysql?
Basically I want to login as the root user and I simply can't.

I do this: mysql> -u root

and nothing happens

when i use the status command it shows that the user is: russjones@localhost

I do not have any problems on windows, but I'd like to use the mac.

Does this have anything to do with a bash profile?

Root User Denied Access To Fetch User List.
I can still log onto MySQL administrator or the command line program but I somehow appear to have lost all priveliges to alter or view the user list from this account. Even under the command line interface I can login but it tells me access is denied when I try to alter "root" permissions on a database.

I cannot seem to log onto any of the other accounts created but obviously if I could get into the user admin I could solve this.

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?

Deleted Root User From 'user' Database!
I so stupidly deleted the root user from my mysql > user database. Now I can't login to mysql. I uninstalled the rpm and reinstalled it but it still won't let me setup a new root user. How can I delete the mysql data files so that I start again, fresh? Where are these files located? I can't find them anywhere after removing the RPM but they are obviously there because upon reinstalling the RPM I'm still in the same position--I try to do

mysqladmin -u root password 'password'

but it says "Access denied for user root@localhost"

No User Root ?
I did install psa software for some testing .. (webhosting software) Thogh I did un-install it and ebverything seemed fine for a few weeks, now this !.. >> mysqladmin: unable to change password; error: 'Can't find any matching row in the user table' . I have followed the instuctions to change password for root user from the mysql documentation.

Root User
I have properly installed via the latest version of Windows Essentials of MySQL, I ran the installer and left it make the job. I have given a password to the root account, but while installing PHPMyAdmin, the programme cannot access the root user.

Root User
my webhosting company defaulted a root user with no password. I created a user for myself with a password, but wondering if having the root user without a password will leave the database open to intrusion. What's it there for, anyways?
On another note, what is a good IDE for developing a PHP/MySQL website that will be served from a UNIX server, but developed on a windows PC?

User Problems... Only Root User "works".
i have been trying to figure this strange problem out for a week or so. here it is.

i have a set of users with various permissions for different reasons. about 2 weeks ago, my hardware suffered a fairly nasty failure. i recovered everything. things seemed to work out. i didnt think to check my phpBB forums or my blog (or other mysql based stuff). never had any problems with the DB... so, maybe i am missing something simple here. i hope so.

what my users can do:

they can log in via command line, a gui i use on mac os x and it does not matter if it is local, or remote. they work just fine.

what all but one users cannot do:

none of my users can run phpbb or the blog stuff.. except for the root user. any other user returns the error message written in the code of which ever script i try to access telling me that "could not connect to DB" etc..

root works fine.

now, i thought maybe it was a problem with the forums and other stuff. but i cant be. same thing happens with all things... even a game server i occasionally run that keeps account info in a DB.

all these users are set up properly and have worked just fine in the past. nothing new has been installed, no conf changes..im at a loss...

Root User Without Privileges?
Anyone know when it will be considered production stable?


Cannot Connect As Root User
I'm new to MySQL and have just installed in on a WinXP Pro system but now I cannot login as the root user. When I key in

mysql -u root

I get

ERROR 1045: Access denied for user 'root@localhost' (Using password: NO)

Also I cannot connect the mysal database. When I type

mysqlshow mysql

I get

mysqlshow: Access denied for user '@localhost' to database 'mysql'

I can't seem to do anything in WinMySQLAdmin. Please help, I've surfed the web and have not been able to find the solution.

User Root Locked Out.
I have mysql 4.0.16 database running on a windows machine, it was
running fine. I didn't use it for a week and now when I try to go into
it and delete some records it tells me access denied for root, I can't
create users or modify anything. When I do a show grants it says all
grants for user root.

Can't Use CREATE USER As Root?
I've just freshly installed mysql on my debian system. Binary from the repository, didn't have the nerve to do a source installation. I did mysql_install_db, set my root pw and logged in. Of course, I wanted to create a new user. But what do I get?

Your MySQL connection id is 1 to server version: 4.0.23_Debian-7-log

Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

mysql> CREATE USER bla;

ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'USER bla' at line 1

Deleted The Root User
i deleted it thorugh phpmyadmin. I wanted to look at its properties... and i pressed the wrong submit button and it was gone. Ive tried deleting all the stuff...
delete /usr/lib/mysql and my.cf and reinstalling... but its still gone. phpyadmin says i dont have permissions to do anything. and webmin says it cant login with ' @localhost' with no password.

I
1) stopped the service
2) yum removed mysql and mysql-server and dependancies
3) removed the database files listed above
4) reinstalled
5) blew up my house because it is still gone

Replace Root User
mysql ships with the default root user. I was wondering (for security) if it was possible to replace the root user with another user account or if the root user had certain privaliges that others could not have.

How To Create User Except Root Account ?
how to create user except root account ?

Connection Refused For Root User
I have installed mysql and thought I knew what I was doing from the last install. I switched OS from win98 to winXP.

All seems ok. Green light is showing. connect fine from command prompt with just mysql command.

But when I try to connect from a perl script the user and password is denied.

Access denied for user: 'yrkylady@localhost' (Using password: YES)

I know the password is correct because I'm getting it from the Admin panel

#This File was made using the WinMySQLAdmin 1.4 Tool
#3/2/2004 6:21:11 PM

#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions

[mysqld]
basedir=C:/mysql
#bind-address=127.0.0.1
datadir=C:/mysql/data
#language=C:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-nt.exe
user=yrkylady
password=sdasldkf

Remote Administrator For Root User
I have got linux server and I want to use Mysql Administrator with root user but it can't accept root user for remote connections how can I fix that or is there any way to do that?

Restore Rights Of User Root
I have the problem that I can't see all databases as user root and I have no longer the right to create new databases. How can I get this right (privilege) back?

Deleted Hostname From Root User
I did something really dumb I deleted the hostname from my main root user and now can't even use the mysql command in console any way i can fix this ???

Can I Set Database User Password When No Root Pw Is Set
I have installed PHPBB MediaWiki and SugarCRM on Ubuntu Server LAMP. I initially tried to set the root password on install and then could not log back in. After reinstall this is what I did for a new non root user.

root@invest:~# mysql -V
mysql Ver 14.12 Distrib 5.0.38, for pc-linux-gnu (i486) using readline 5.2

grant CREATE,INSERT,DELETE,UPDATE,SELECT on pauldb.* to paul@localhost;

set password for paul = password('mysecretpassword');

flush privileges;
exit;

Then when i go to login with this user I can't.

I have not set a password for root because the same thing happened when I tried to set root pw immediately after install of the database. This time I am trying to work out the access issue with a new user i have created. This way I still have access since and I won't have to reinstall the db.

Can Not Change Password For Root-user
I can't seem to change the password for my root-user in MySQL.

When I go into mysql and type;

UPDATE mysql.user SET Password=PASSWORD('mypassword') WHERE User='root' AND Host='localhost';

I get the following error;

ERROR 1044: Access denied for user: '@localhost' to database 'mysql'

How can I change my root-password in the best way?

Change The Root User Password
I have just set a password for the root user for logging into MySQL which all works fine by typing: mysql -u root -p
A prompt appears asking me for my password which I enter and the usual welcome message appears.I initally set my root user password by typing at command line:
mysqladmin -u root password "new password"
("new password" being the password I chose)
This all worked ok. However I would like to know how to I change the password for the root user, and how would I also change the password for users that I set up (I assume it would be a similar way)?

I am currently running all on my local machine (hence no need to use "-h" anywhere in the login procedure) and running on windows 2000.

Using Non Root User To LOAD DATA INFILE
I am trying to set up a web app that will allow admin users to upload .csv files. those files are then processed and imported into the MySql db.

I keep getting a

42000Access denied for user 'username' to database 'db'

error.

I have checked the user's permissions, and they have as much access as i can give them to the particular db.

Access Denied For User 'root'@'localhost'
I am having this error message:

Check the pictures

#1045 - Access denied for user 'root'@'localhost' (using password: YES)

I am using WAMP5,I tried to change the password in config file but no use.last time I had to uninstall and reinstall to reset the root password.

what am I doing wrong?am I looking at the wrong file?

Warning: One Can Only Use The -- User Switch If Running As Root
I started the mysql database with the "safe_mysqld" command and with
the user who own mysql. in the errr-log file, I have that:

050123 23:16:50 mysqld started
Warning: One can only use the --user switch if running as root
/exlibris/sfx_ver/sfx_version_2/app/mysql/libexec/mysqld: ready for
connections

What is the meaning of

"Warning: One can only use the --user switch if running as root" ?

Access Denied For User 'root@localhost'
I have installed MySQL and somehow have my forum running fine using it, however, I am attempting to install Photopost php software and I have put in the user name that I have been using.

It all works fine up until it tries to create tables on the database (and maybe even a database, the error message isn't telling me much).

I have tried to log into mySQL but keep getting the error:

ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

The error I get from the install page (of Photopost) is:


Could not connect to or create the PhotoPost Classifieds database.

Be sure your user has permissions to CREATE or create a blank table before hitting REFRESH or go back to Step 1 to check your database settings.



Presumably I need to go in to mySQL as root and set CREATE etc... permissions for the user that I have specified in the Photopost install script?

How can I do this? I have never set up a root password for mySQL.

I am completely new to MySQL (although I have used it for my own developments on Windows, but never on Linux).

Return Back All The Privleadges To The Root User
I accidently remove all the privleadges of the root user of MySQL on a web hosting server.I need your help that how i can return back all the privleadges to the root user.

Access Denied For User 'root'@'localhost' (using Password: YES)
I am trying to login to mysql using 'mysql -u root -p' with password.but iam getting this error "Access denied for user 'root'@'localhost' (using password: YES)".

i have googled for this error and i saw that if i enter a wrong password i get this error.but i am 100% sure that the password is right because i used it in a sample program where i gave that password to connect to mysql.

Access Denied For User 'root'@'localhost' (using Password: NO)
i've use ASP before though with microsoft access db, odbc connection. I'ved tried installing the php windows installer to my winxp(with IIS) and then mysql server 4.3.1  everything installed Code:

Access Denied For User 'root'@'host' To Database 'db'
i'm trying to connect from a remote host to a db, and I just cannot. I can make a successful connection to another db (test), but not to the productive db.

I have tried some things (flush privileges, grant everything), but I still cannot connect to the db.

Error: 'Access Denied For User 'root'@'localhost'
I've used mysql on an XP machine before, but only a little. I installed Fedora core 5 on this machine (i386) and have mysql 5.0 running.

I understand that this is a common problem and I have been searching for a solution for a few days now.

When I was configuring Fedora using this guide (FYI: I only installed what I needed), I used this command to set the root password (assuming that I was using 'root' as my password):
mysqladmin -u root password root
Then, I tried this command to login (as instructed by the guide I was following):
mysqladmin -h localhost -u root password root
This is where I got the error:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

Now, I have tried many methods to fix this. I tried every method to reset the root password as instructed by the mysql documentation. I also installed Fedora core 5 on another hard drive at home to see if I would still get the same error and I did. I know that localhost is the correct host name and the mysql service was running while I was trying to login. I've read a lot of post here already and nothing has helped me.

Error: 'Access Denied For User: 'root@localhost' (Using Password: NO)'
I've installed MySQL 4.0.26 on OSX 10.3.9 client version using the standard darwin 7.9.0 PKG. Installation seemed to go fine but I can only access Mysql with
urs/local/mysql/bin/mysql test

To my knowledge I never sent a root or user password.
When I come to try and set a password or create a database I am asked for my password.
When I try and enter it the imput is frozen and the only keystroke that will work is 'enter' then I get a error message that tells me that it is the incorrect password.
I have tried all of the different login and password reset commands I can find but to no avail.

ERROR 1045 (28000): Access Denied For User 'root'@'localhost'
Using mySQL 4.1.22 on Linux, I got this error message suddenly this morning (it worked ok yesterday):
---------
[root@server]# /usr/local/mysql/bin/mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
----------

I created a '/root/root.sql' file:
--------
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('xxxxxx');
--------

And killed the process and restarted:
--------
[root@server ~]# /usr/local/mysql/bin/mysqld_safe --init-file=/root/root.sql &
[1] 2494
[root@server ~]# Starting mysqld daemon with databases from /usr/local/mysql/var
--------

But I get the same error message

In my '/usr/local/mysql/var/server.err' file there's no error message:
--
070220 07:03:40 mysqld started
070220 07:03:40 InnoDB: Started; log sequence number 0 3758734
/usr/local/mysql/libexec/mysqld: ready for connections.
Version: Ɗ.1.22' socket: '/tmp/mysql.sock' port: 3306 Source distribution
-------

ERROR 1045 (28000): Access Denied For User 'root'@'localhost'
Using mySQL 4.1.22 on Linux, I got this error message suddenly this morning (it worked ok yesterday):

---------
[root@server]# /usr/local/mysql/bin/mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
----------

I created a '/root/root.sql' file:
--------
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('xxxxxx');
--------

And killed the process and restarted:
--------
[root@server ~]# /usr/local/mysql/bin/mysqld_safe --init-file=/root/root.sql &
[1] 2494
[root@server ~]# Starting mysqld daemon with databases from /usr/local/mysql/var
--------

But I get the same error message :(

In my '/usr/local/mysql/var/server.err' file there's no error message:
--
070220 07:03:40 mysqld started
070220 07:03:40 InnoDB: Started; log sequence number 0 3758734
/usr/local/mysql/libexec/mysqld: ready for connections.
Version: '4.1.22' socket: '/tmp/mysql.sock' port: 3306 Source distribution
-------

What am I doing wrong?

ERROR 1045 (28000): Access Denied For User 'root'@'localhost'
I'm attempting to install Bugzilla.

I'm stuck because the last two modules that are required in Perl won't run. The apparent reason is that the root login fails.

I tried it manually to, and here's what I get:

[root@10 bugzilla-2.18.3]# mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

I created the database and login via a Perl module called template:

/opt/ActivePerl-5.8/bin/perl-static -MCPAN -e 'install "Template"'

ERROR 1045 (28000): Access Denied For User 'root'@'localhost'
Using mySQL 4.1.22 on Linux, I got this error message suddenly this morning (it worked ok yesterday):
---------
[root@server]# /usr/local/mysql/bin/mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
----------

I created a '/root/root.sql' file:
--------
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('xxxxxx');
--------

And killed the process and restarted:
--------
[root@server ~]# /usr/local/mysql/bin/mysqld_safe --init-file=/root/root.sql &
[1] 2494
[root@server ~]# Starting mysqld daemon with databases from /usr/local/mysql/var
--------

But I get the same error message :(

In my '/usr/local/mysql/var/server.err' file there's no error message:
--
070220 07:03:40  mysqld started
070220 07:03:40  InnoDB: Started; log sequence number 0 3758734
/usr/local/mysql/libexec/mysqld: ready for connections.
Version: '4.1.22'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
-------

What am I doing wrong?

Access Denied For User 'root'@'localhost' (was "help!!! Just A Beginner..")
Hello i recently installed WAMP5 to handle my phpmysqlapache localhost sever. but when i go to the control panel and clicked the localhost and phpmyadmin everything seems fine because i can see the phpinfo window and also the phpmyadmin.. but not when i clicked the SQLite Manager.Unable to connect to database manager.
Could not connect: Access denied for user 'root'@'localhost' (using password: YES).

ERROR 1045: Access Denied For User: '"root"@localhost' (Using Password: YES)
I have been working on this for three days (about 16 hours) to no avail. I have root access on a dedicated server running whm/cpanel on Redhat 9. I have followed every instruction from mysql.com as well as every suggestion I've been able to find.

These are the two errors I bounce between:

ERROR 1045: Access denied for user: '"root"@localhost' (Using password: YES)

and

ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

I'm out of ideas.

How To Change "#1226 - User 'root' Has Exceeded The 'max_questions' Resource" Error
I seem to have set a max_questions variable on my system and my admin console and command prompt don't work with this response:

"#1226 - User 'root' has exceeded the 'max_questions' resource"

How to fix?

And how do I not make thisw mistake again?

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).


Copyright © 2005-08 www.BigResource.com, All rights reserved