http://www.mysql.com/doc/en/Automatic_start.html
If you have not my.cnf file you can create a new one with a text editor. Just write your options and then save it to the required place with the name "my.cnf".
If you enter a password for user root try "/usr/bin/mysqladmin -u root -p" then hit return. It will ask you the password. Type your password and it is ok.
Vidiot wrote:
I installed the Linux RPMs for the latest version of MySQL. But, no my.cnf.
How do I create one? I can't find anything in the 800+ page manual on how
to create said file.
I can't get any of the programs to work either. The mysql daemon starts,
the firewall has a hole cut in it for my IP to get through port 3306, but
it doesn't help:
mrvideo.ZROOT <6> /usr/bin/mysqlshow
/usr/bin/mysqlshow: Access denied for user: 'root@localhost' (Using password: NO)
mrvideo.ZROOT <3> /usr/bin/mysqladmin -u root -h localhost password xxxxxxxxxxx
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
mrvideo.ZROOT <7> /usr/bin/mysqladmin -u root -h mrvideo password vidiot90210
/usr/bin/mysqladmin: connect to server at 'mrvideo' failed
error: 'Host 'mrvideo.vidiot.com' is not allowed to connect to this MySQL server'
I previously posted the following query, which hasn't resulted in any responses,
so I'll try again...
Date: Sun, 1 Dec 2002 02:31:59 -0600 (CST)
I found the following RPMs:
perl-DBD-MySQL-1.2215-1.i386.rpm
perl-DBI-1.14-10.i386.rpm
But they aren't good enough:
rpm -ivh MySQL*3.23.53a-1.i386.rpm perl-DBD-MySQL-1.2215-1.i386.rpm perl-DBI-1.
14-10.i386.rpm error: failed dependencies:
MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.53a-1
Just what the hell is the person looking for that packaged the bench RPM?
It would be nice if the MySQL page that has the Linux RPMs would list the
dependencies and where to get the RPMs that it needs. But, nope, nada.
Until I can find that particular RPM, the "bench" RPM will be left off the
list.
I'm attempting to install the following Linux RPMs:
MySQL-3.23.53a-1.i386.rpm MySQL-client-3.23.53a-1.i386.rpm
MySQL-Max-3.23.53a-1.i386.rpm MySQL-devel-3.23.53a-1.i386.rpm
MySQL-bench-3.23.53a-1.i386.rpm MySQL-shared-3.23.53a-1.i386.rpm
When I do so I get the following error:
rpm -ivh MySQL*3.23.53a-1.i386.rpm
error: failed dependencies:
MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.53a-1
The only Perl DBI module on the MySQL website is the DBI-1.18.tar.gz tarball.
Where is said RPM located?
Thanks for any pointers to the location.
MB
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
