[NTLUG:Discuss] Still NO Mysql - Is there at least a MySQL Mailing list?

[Stephen Davidson]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi Terry.

Thanks.  Unfortunately, SuSE uses Yast instead of Apt-get, and SuSE 10.3
is preconfigured for MySQL 5.0.  Hence the manual install -- "I was
outside of the box".  I did eventually get that part worked out.  There
were some leftover 5.0 files causing an issue (these files did NOT
include my.cnf, btw -- I had to create my own as one was notinstalled
with 5.1!).

Now, my current issue is that Stored Procedures in the mysql 5.0 dump
file will not be imported into mysql 5.1.  :(

Regards,
Steve

terry wrote:
> This might give you a clue,  (notes from a debian user's mysql install):
> 
> =======================================================
> 
> In order to install MySQL, we run
> 
> apt-get install mysql-server mysql-client libmysqlclient15-dev
> 
> You will be asked to provide a password for the MySQL root user - this
> password is valid for the user root at localhost as well as
> root at server1.example.com, so we don't have to specify a MySQL root password
> manually later on:
> 
> New password for the MySQL "root" user: <-- yourrootsqlpassword
> Repeat password for the MySQL "root" user: <-- yourrootsqlpassword
> 
> We want MySQL to listen on all interfaces, not just localhost, therefore we
> edit /etc/mysql/my.cnf and comment out the line bind-address = 127.0.0.1:
> 
> vi /etc/mysql/my.cnf
> 
> [...]
> # Instead of skip-networking the default is now to listen only on
> # localhost which is more compatible and is not less secure.
> #bind-address           = 127.0.0.1
> [...]
> 
>   Then we restart MySQL:
> 
> /etc/init.d/mysql restart
> 
> Now check that networking is enabled. Run
> 
> netstat -tap | grep mysql
> 
> The output should look like this:
> 
> server1:~# netstat -tap | grep mysql
> tcp        0      0 *:mysql                 *:*
> LISTEN      6612/mysqld
> server1:~#
> _______________________________________________
> http://www.ntlug.org/mailman/listinfo/discuss

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4-svn0 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org

iD8DBQFJpodRSphIUSiVzgYRAqJNAJ9rUPn7db/dmgbgpMMSpwFpqPNeVgCeNDcx
75ipwOjsbI5W1YfvloM2jPo=
=ePdK
-----END PGP SIGNATURE-----