Re: Installation Confusion in Linux
On Tue, 2004-02-17 at 17:08, Ross O wrote: [EMAIL PROTECTED] root]# rpm -qvl MySQL-server-4.0.18-0 -rwxr-xr-x1 rootroot 5575 Feb 12 09:02 /etc/init.d/mysql -rw-r--r--1 rootroot 657 Feb 12 09:02 /etc/logrotate.d/mysql -rwxr-xr-x1 rootroot 900144 Feb 12 Hi! As you can see, there is only server related stuff installed, there is not client and administration stuff installed. On Tue, 2004-02-17 at 18:04, Ross O wrote: So I need to install the client as well as the server? I thought I read on the MySQL site that I only need the server for a single user, single computer database? Most probably yes, however i must mention one thing, you can perfectly install the server (and only) the server in a linux machine, that would be the server machine, and administer it remotly, that can be a perfectly normal situation. The server packages contains only the service files, the binaries needed for a working mysql-server, on the other side, the client-file contains administration utilities and client files (a command line utilities called mysql - like oracle's plsql, for example; and the mysqladmin wich you can use to administer the server) So, it's up to you friend, you can have a linux-mysql server with only server related stuff installed and access it and manage it remotly (from yout windows desktop, as an example) using any gui tool you want; or, you can install the client files also, and manage your server via the command line and locally in your server. Any of the two are perfectly fine options, most people here will tell you (i guess) that we use both options, i mean; a remote, nice, gui utility and the command line tool :) As an extra, may i recommend some tools? 1.- mysql administrator is a brand new tool to administer and monitor a mysql server, it runs just fine in win and lin, it's free, and directly supported by mysql. You can download it from mysql site 2.- dbtools is a mysql administration and design tool by a few very nice brazilian guys it works only on windows, and also support PostgreSQL. You can download the basic-free version from the www.dbtools.com.br site. 3.- the mysql command line tools is indeed very nice, despite being a command line tool, is my favorite tool and is VERY good excuse to really learn about sql and mysql command syntax, very nice also to prepapre for the certification :) Hope this helps! Best Regards! -- |...| | _ _|Victor Medina M | |\ \ \| | _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | |/_/_/|_|_| /_/ \_\|ext. 325 - Tél: +58-241-8507325 | ||geek by nature - linux by choice | |...| -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Installation Confusion in Linux
I was able to successfully install MySQL server 4 under windows, but am a little confused about doing it through linux. My main confusion is where the install goes? Im using the rpm, and from my personal directory where i downloaded the rpm to, i issue a rpm -i MySQL-server-...rpm command and it goes through its deal. The very first thing I notice is it says is to execute /usr/bin/mysqladmin -u root... to set the passwords. Well there are about a dozen mysql scripts in that directory but no mysqladmin, so immediately Im thinking i have a problem or did something wrong. Next it says the default directory for the install is /usr/local/mysql unless i specified otherwise. I did not and that directory does not exist. so what happened? i downloaded the rpm off the mysql site and all i did was run it. didnt touch anything else. it installs the mysql service fine, and it puts all its db files in the /var/lib directory like it says it will, but it sure seems like im missing some other critical files? __ Do you Yahoo!? Yahoo! Finance: Get your refund fast by filing online. http://taxes.yahoo.com/filing.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Installation Confusion in Linux
This will list all the files in the package and where they are located. rpm -qpl package_name.rpm or from the rpm database rpm -ql pachage_name Matt Ross O wrote: I was able to successfully install MySQL server 4 under windows, but am a little confused about doing it through linux. My main confusion is where the install goes? Im using the rpm, and from my personal directory where i downloaded the rpm to, i issue a rpm -i MySQL-server-...rpm command and it goes through its deal. The very first thing I notice is it says is to execute /usr/bin/mysqladmin -u root... to set the passwords. Well there are about a dozen mysql scripts in that directory but no mysqladmin, so immediately Im thinking i have a problem or did something wrong. Next it says the default directory for the install is /usr/local/mysql unless i specified otherwise. I did not and that directory does not exist. so what happened? i downloaded the rpm off the mysql site and all i did was run it. didnt touch anything else. it installs the mysql service fine, and it puts all its db files in the /var/lib directory like it says it will, but it sure seems like im missing some other critical files? __ Do you Yahoo!? Yahoo! Finance: Get your refund fast by filing online. http://taxes.yahoo.com/filing.html -- Matt Silva Empower Software Technologies, LLC 27851 Bradley Rd. Suite 120 Sun City, CA 92586 PH: (909) 672-6257 WB: www.storagecommander.com EM: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Installation Confusion in Linux
Ross, rpm -qlp package_name.rpm will list all the files in an rpm for you. You may need to install the client rpm as well. walt Ross O wrote: I was able to successfully install MySQL server 4 under windows, but am a little confused about doing it through linux. My main confusion is where the install goes? Im using the rpm, and from my personal directory where i downloaded the rpm to, i issue a rpm -i MySQL-server-...rpm command and it goes through its deal. The very first thing I notice is it says is to execute /usr/bin/mysqladmin -u root... to set the passwords. Well there are about a dozen mysql scripts in that directory but no mysqladmin, so immediately Im thinking i have a problem or did something wrong. Next it says the default directory for the install is /usr/local/mysql unless i specified otherwise. I did not and that directory does not exist. so what happened? i downloaded the rpm off the mysql site and all i did was run it. didnt touch anything else. it installs the mysql service fine, and it puts all its db files in the /var/lib directory like it says it will, but it sure seems like im missing some other critical files? __ Do you Yahoo!? Yahoo! Finance: Get your refund fast by filing online. http://taxes.yahoo.com/filing.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Installation Confusion in Linux
[EMAIL PROTECTED] root]# rpm -qvl MySQL-server-4.0.18-0 -rwxr-xr-x1 rootroot 5575 Feb 12 09:02 /etc/init.d/mysql -rw-r--r--1 rootroot 657 Feb 12 09:02 /etc/logrotate.d/mysql -rwxr-xr-x1 rootroot 900144 Feb 12 09:02 /usr/bin/isamchk -rwxr-xr-x1 rootroot 850824 Feb 12 09:02 /usr/bin/isamlog -rwxr-xr-x1 rootroot 777428 Feb 12 09:02 /usr/bin/my_print_defaults -rwxr-xr-x1 rootroot 874860 Feb 12 09:02 /usr/bin/myisam_ftdump -rwxr-xr-x1 rootroot 1011640 Feb 12 09:02 /usr/bin/myisamchk -rwxr-xr-x1 rootroot 919496 Feb 12 09:02 /usr/bin/myisamlog -rwxr-xr-x1 rootroot 942548 Feb 12 09:02 /usr/bin/myisampack -rwxr-xr-x1 rootroot 2977 Feb 12 09:02 /usr/bin/mysql_convert_table_format -rwxr-xr-x1 rootroot10419 Feb 12 09:02 /usr/bin/mysql_explain_log -rwxr-xr-x1 rootroot 483 Feb 12 09:02 /usr/bin/mysql_fix_extensions -rwxr-xr-x0 rootroot 6927 Feb 12 09:02 /usr/bin/mysql_fix_privilege_tables -rwxr-xr-x1 rootroot14289 Feb 12 09:02 /usr/bin/mysql_install_db -rwxr-xr-x1 rootroot 6308 Feb 12 09:02 /usr/bin/mysql_secure_installation -rwxr-xr-x1 rootroot17275 Feb 12 09:02 /usr/bin/mysql_setpermission -rwxr-xr-x1 rootroot 3123 Feb 12 09:02 /usr/bin/mysql_zap -rwxr-xr-x0 rootroot10317 Feb 12 09:02 /usr/bin/mysqlbug -rwxr-xr-x1 rootroot18919 Feb 12 09:02 /usr/bin/mysqld_multi -rwxr-xr-x1 rootroot10714 Feb 12 09:02 /usr/bin/mysqld_safe -rwxr-xr-x1 rootroot31748 Feb 12 09:02 /usr/bin/mysqlhotcopy -rwxr-xr-x1 rootroot 744760 Feb 12 09:02 /usr/bin/mysqltest -rwxr-xr-x1 rootroot 863104 Feb 12 09:02 /usr/bin/pack_isam -rwxr-xr-x1 rootroot 771724 Feb 12 09:02 /usr/bin/perror -rwxr-xr-x1 rootroot 779312 Feb 12 09:02 /usr/bin/replace -rwxr-xr-x1 rootroot 770452 Feb 12 09:02 /usr/bin/resolve_stack_dump -rwxr-xr-x1 rootroot 771336 Feb 12 09:02 /usr/bin/resolveip lrwxr-xr-x1 rootroot 13 Feb 12 09:02 /usr/bin/safe_mysqld - ./mysqld_safe -rw-r--r--1 rootroot 413255 Feb 12 09:02 /usr/lib/mysql/mysqld.sym -rwxr-xr-x1 rootroot 4062636 Feb 12 09:02 /usr/sbin/mysqld lrwxr-xr-x1 rootroot 17 Feb 12 09:02 /usr/sbin/rcmysql - /etc/init.d/mysql drwxr-xr-x2 rootroot0 Feb 12 09:02 /usr/share/doc/packages/MySQL-server -rw-r--r--1 rootroot19106 Feb 10 10:18 /usr/share/doc/packages/MySQL-server/COPYING -rw-r--r--1 rootroot 1937 Feb 10 10:15 /usr/share/doc/packages/MySQL-server/README -rw-r--r--1 rootroot 3475464 Feb 10 10:18 /usr/share/doc/packages/MySQL-server/manual.html -rw-r--r--1 rootroot 117 Feb 10 10:39 /usr/share/doc/packages/MySQL-server/manual.ps -rw-r--r--1 rootroot 3175929 Feb 10 10:16 /usr/share/doc/packages/MySQL-server/manual.texi -rw-r--r--1 rootroot 3019963 Feb 10 10:18 /usr/share/doc/packages/MySQL-server/manual.txt -rw-r--r--1 rootroot 134754 Feb 10 10:18 /usr/share/doc/packages/MySQL-server/manual_toc.html -rw-r--r--1 rootroot 4866 Feb 12 09:02 /usr/share/doc/packages/MySQL-server/my-huge.cnf -rw-r--r--1 rootroot 4842 Feb 12 09:02 /usr/share/doc/packages/MySQL-server/my-large.cnf -rw-r--r--1 rootroot 4825 Feb 12 09:02 /usr/share/doc/packages/MySQL-server/my-medium.cnf -rw-r--r--1 rootroot 2410 Feb 12 09:02 /usr/share/doc/packages/MySQL-server/my-small.cnf -rw-r--r--1 rootroot 905192 Feb 12 09:02 /usr/share/info/mysql.info.gz -rw-r--r--1 rootman 1780 Feb 12 09:02 /usr/share/man/man1/isamchk.1.gz -rw-r--r--1 rootman 975 Feb 12 09:02 /usr/share/man/man1/isamlog.1.gz -rw-r--r--1 rootman 664 Feb 12 09:02 /usr/share/man/man1/mysql_fix_privilege_tables.1.gz -rw-r--r--1 rootman 765 Feb 12 09:02 /usr/share/man/man1/mysql_zap.1.gz -rw-r--r--1 rootman 4154 Feb 12 09:02 /usr/share/man/man1/mysqld.1.gz -rw-r--r--1 rootman 1277 Feb 12 09:02 /usr/share/man/man1/mysqld_multi.1.gz -rw-r--r--1 rootman 1047 Feb 12 09:02 /usr/share/man/man1/mysqld_safe.1.gz -rw-r--r--1 rootman 855 Feb 12 09:02 /usr/share/man/man1/perror.1.gz -rw-r--r--0 rootman 961 Feb 12 09:02 /usr/share/man/man1/replace.1.gz drwxr-xr-x2 rootroot0 Feb 12 09:02 /usr/share/mysql -rwxr-xr-x1 root