Re: Can't Access Via Webmin or PhpMyAdmin.
Mark Sargent wrote: Hi All, I can start mysql with the following cmd, /etc/rc.d/init.d/mysql start although, I had to change bindir=./bin to bindir=/usr/local/mysql/bin to get it to work. I can access the DB with, mysql -h localhost -u root -p successfully, but, when trying to access via phpmyadmin or webmin it doesn't work. I've set the config files to what I believe are correct. phpmyadmin error below, Error *MySQL said: *Documentation http://dev.mysql.com/doc/mysql/en/Error-returns.html | #2002 - Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) ||Now, I've got user as root and no password, as I haven't set 1 yet. Why am I getting this.? Anyone seen this before.? With webmin, I get this displayed, |*MySQL is not running on your system - database list could not be retrieved. *Click this button to start the MySQL database server on your system with the command /etc/rc.d/init.d/mysql start. This Webmin module cannot administer the database until it is started. even though the server is running, confirmed with the following, [EMAIL PROTECTED] ~]# ps -uxwww | grep mysql Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.3/FAQ root 4640 0.0 0.2 4180 1116 ?S14:19 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/localhost.localdomain.pid root 4771 0.0 0.0 1580 124 pts/2R+ 14:36 0:00 grep mysql Is anyone on here running webmin to manage mysql..? I'm curious how you got it to run..? If I stop the server via cli and then click the start mysql server button on the webmin page, it goes back to the same message, but, the server is started. I changed the config module page to reflect my installation. What have I missed, perhaps..? Cheers. Mark Sargent. Hi All, below is the config of webmin mysql module, *Path to mysqlshow command* /usr/bin/mysqlshow *Path to mysqladmin command*/usr/local/mysql/bin/mysqladmin *Path to mysql command* /usr/local/mysql/bin/mysql *Path to mysqldump command* /usr/local/mysql/bin/mysqldump *Path to mysqlimport command* /usr/local/mysql/bin/mysqlimport *Command to start MySQL server* /etc/rc.d/init.d/mysql start *Command to stop MySQL server* /etc/rc.d/init.d/mysql stop *Path to MySQL shared libraries directory* *Path to MySQL databases directory* /var/lib/mysql I hope that helps. Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can't Access Via Webmin or PhpMyAdmin.
Hi All, I can start mysql with the following cmd, /etc/rc.d/init.d/mysql start although, I had to change bindir=./bin to bindir=/usr/local/mysql/bin to get it to work. I can access the DB with, mysql -h localhost -u root -p successfully, but, when trying to access via phpmyadmin or webmin it doesn't work. I've set the config files to what I believe are correct. phpmyadmin error below, Error *MySQL said: *Documentation http://dev.mysql.com/doc/mysql/en/Error-returns.html | #2002 - Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) ||Now, I've got user as root and no password, as I haven't set 1 yet. Why am I getting this.? Anyone seen this before.? With webmin, I get this displayed, |*MySQL is not running on your system - database list could not be retrieved. *Click this button to start the MySQL database server on your system with the command /etc/rc.d/init.d/mysql start. This Webmin module cannot administer the database until it is started. even though the server is running, confirmed with the following, [EMAIL PROTECTED] ~]# ps -uxwww | grep mysql Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.3/FAQ root 4640 0.0 0.2 4180 1116 ?S14:19 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/localhost.localdomain.pid root 4771 0.0 0.0 1580 124 pts/2R+ 14:36 0:00 grep mysql Is anyone on here running webmin to manage mysql..? I'm curious how you got it to run..? If I stop the server via cli and then click the start mysql server button on the webmin page, it goes back to the same message, but, the server is started. I changed the config module page to reflect my installation. What have I missed, perhaps..? Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [MySQL] mysql/snort/webmin/permissions
Mark Sargent wrote: Ashley M. Kirchner wrote: Mark Sargent wrote: [EMAIL PROTECTED] pcre-5.0]# mysql -h mysql -p -bash: mysql: command not found You don't have mysql in root's path. Once you fix that little problem, you should be all set. Hi All, heck, how exactly do I do that..? Move the whole mysql dir to a path dir..? Why is this so, when I followed the install steps from mysql's site. Hmm, damn annoying. Cheers. I followed the below from their install page, If you run into problems, /please always use *mysqlbug*/ when posting questions to a MySQL mailing list. Even if the problem isn't a bug, *mysqlbug* gathers system information that helps others solve your problem. By not using *mysqlbug*, you lessen the likelihood of getting a solution to your problem. You can find *mysqlbug* in the |bin| directory after you unpack the distribution. See Section 1.4.1.3, How to Report Bugs or Problems http://dev.mysql.com/doc/mysql/en/bug-reports.html. The basic commands you must execute to install and use a MySQL binary distribution are: shell groupadd mysql shell useradd -g mysql mysql shell cd /usr/local shell gunzip /|/path/to/mysql-VERSION-OS|/.tar.gz | tar xvf - shell ln -s /|full-path-to-mysql-VERSION-OS|/ mysql shell cd mysql shell scripts/mysql_install_db --user=mysql shell chown -R root . shell chown -R mysql data shell chgrp -R mysql . shell bin/mysqld_safe --user=mysql For versions of MySQL older than 4.0, substitute *bin/safe_mysqld* for *bin/mysqld_safe* in the final command. Mark Sargent. Hi All, guys, my sincere apologies, I just didn't do enuff research on things. I do have a Fedora book, and took a better look at it last night. I now understand what is required, and have successfully got things running. I appreciate your pateince with me. Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [MySQL] mysql/snort/webmin/permissions
Ashley M. Kirchner wrote: Mark Sargent wrote: [EMAIL PROTECTED] pcre-5.0]# mysql -h mysql -p -bash: mysql: command not found You don't have mysql in root's path. Once you fix that little problem, you should be all set. Hi All, heck, how exactly do I do that..? Move the whole mysql dir to a path dir..? Why is this so, when I followed the install steps from mysql's site. Hmm, damn annoying. Cheers. I followed the below from their install page, If you run into problems, /please always use *mysqlbug*/ when posting questions to a MySQL mailing list. Even if the problem isn't a bug, *mysqlbug* gathers system information that helps others solve your problem. By not using *mysqlbug*, you lessen the likelihood of getting a solution to your problem. You can find *mysqlbug* in the |bin| directory after you unpack the distribution. See Section 1.4.1.3, How to Report Bugs or Problems http://dev.mysql.com/doc/mysql/en/bug-reports.html. The basic commands you must execute to install and use a MySQL binary distribution are: shell groupadd mysql shell useradd -g mysql mysql shell cd /usr/local shell gunzip /|/path/to/mysql-VERSION-OS|/.tar.gz | tar xvf - shell ln -s /|full-path-to-mysql-VERSION-OS|/ mysql shell cd mysql shell scripts/mysql_install_db --user=mysql shell chown -R root . shell chown -R mysql data shell chgrp -R mysql . shell bin/mysqld_safe --user=mysql For versions of MySQL older than 4.0, substitute *bin/safe_mysqld* for *bin/mysqld_safe* in the final command. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql/snort/webmin/permissions
Hi All, coupla questions. 1stly, I can access mysql from webmin and start it, along with being able to start/stop with service mysql start/stop from cli. I'm also following this tutorial, by Patrick Harper, http://216.239.57.104/search?q=cache:GHt0q9MF1coJ:www.infosecwriters.com/text_resources/pdf/snort_base_fc3.pdf+snort+on+fedora+3hl=enclient=firefox-a for snort/php/mysql/FC3/apache/ssl and wanna know why I can't access mysql from the prompt with mysql -h mysql -p. All I get is, [EMAIL PROTECTED] pcre-5.0]# mysql -h mysql -p -bash: mysql: command not found I want to be able to do the following from this tutorial, mysql SET PASSWORD FOR [EMAIL PROTECTED]('password'); Query OK, 0 rows affected (0.25 sec) mysql create database *snort*; Query OK, 1 row affected (0.01 sec) mysql grant INSERT,SELECT on root.* to [EMAIL PROTECTED]; Query OK, 0 rows affected (0.02 sec) mysql SET PASSWORD FOR [EMAIL PROTECTED]('password_from_snort.conf'); Query OK, 0 rows affected (0.25 sec) mysql grant CREATE, INSERT, SELECT, DELETE, UPDATE on *snort*.* to [EMAIL PROTECTED]; Query OK, 0 rows affected (0.02 sec) mysql grant CREATE, INSERT, SELECT, DELETE, UPDATE on *snort*.* to *snort*; Query OK, 0 rows affected (0.02 sec) mysql exit bye I used webmin to create a new DB, snort, and gave permission to Username snort to create, insert, delete, select and update from host permissions. Is it the same as above..? 1st time to use webmin/mysql/snort/apache. Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [MySQL] mysql/snort/webmin/permissions
Mark Sargent wrote: [EMAIL PROTECTED] pcre-5.0]# mysql -h mysql -p -bash: mysql: command not found You don't have mysql in root's path. Once you fix that little problem, you should be all set. -- H | I haven't lost my mind; it's backed up on tape somewhere. + Ashley M. Kirchner mailto:[EMAIL PROTECTED] . 303.442.6410 x130 IT Director / SysAdmin / WebSmith . 800.441.3873 x130 Photo Craft Imaging . 3550 Arapahoe Ave. #6 http://www.pcraft.com . . .. Boulder, CO 80303, U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
By mistake I removed root server of localhost thru webmin
Dear List, I have removed root user of localhost thru webmin and now i am not able to login into MySQL Interface of webmin as it says Incorrect user name and password when I try to enter as any user [root or any XYZ user], please tell me how to create this user for MySQL so that I can access this interface again. Please note that I am able to use root login for all other purposes but Webmin does not allow to enter into MySQL Interface only. Regards, Vivek - 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
ARG! Anyone using webmin on Solaris to manage MySQL?
I have tried the last 10 releases of webmin and cannot get it to work with MySQL. I have a standard install of Mysql 3.23 into /usr/local/mysql. Webmin keeps complaining that it cannot find the libraries. The MySQL libraries are here: /usr/local/mysql/lib/mysql I have set that path both in the config and LD_LIBRARY_PATH. I have tried copying all the mysql libs to /lib and pointing to them there. Nothing has worked. Anyone have better luck on Solaris 8? (I have tried this on 4 Solaris 8 systems) Thanks, CC - 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
Search results are differant on console and in webmin
I sometimes access mysql through webmin and sometimes via the console (using telnet from a remote machine). I have a table of users (name,password,login) and when I view it on the console I see a few fields appear to be missing a few characters. When I view it via webmin those same fields show all their characters. Any idea what the problem could be? (Or is it actually a problem?) Chip Wiegand Computer Services www.simradusa.com [EMAIL PROTECTED] Simrad, Inc Lynnwood, WA 425-712-1138 There is no reason anyone would want a computer in their home. --Ken Olson, president, chairman and founder of Digital Equipment Corp., 1977 (-- Then why do I have nine? Somebody help me!) - 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
Antwort: Webmin
On 14.03.2001 22:33:13 Charles L Hagen wrote: Has anyone found a GUI for MySQL on a Linux box? I found Webmin, but it seems limited. Is there an HTML GUI for MySQL? phpMyAdmin - see freshmeat - 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
Re: Antwort: Webmin
Hi, alexander.skwar, Mysql has the type as the MSSQL BIT??? Regards, Sunrise [EMAIL PROTECTED] - 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
Antwort: Re: Antwort: Webmin
On 15.03.2001 10:23:19 Sunrise wrote: Hi, alexander.skwar, Mysql has the type as the MSSQL BIT??? Pardon me? What do you mean? - 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
Re: Antwort: Webmin
Sunrise wrote: Hi, alexander.skwar, Mysql has the type as the MSSQL BIT??? Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) Yes and this is documented in manual. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - 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
Webmin
Has anyone found a GUI for MySQL on a Linux box? I found Webmin, but it seems limited. Is there an HTML GUI for MySQL? -- Charles L. Hagen - 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
Re: Webmin
Has anyone found a GUI for MySQL on a Linux box? I found Webmin, but it seems limited. Is there an HTML GUI for MySQL? You could try "MysqlTool". It's a Perl program. Haven't really used it yet, but it looks good. Adam -- Adam Stein @ Xerox Corporation Email: [EMAIL PROTECTED] Disclaimer: All views expressed here have been proved to be my own. [http://www.csh.rit.edu/~adam/] - 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
Re: Webmin
Has anyone found a GUI for MySQL on a Linux box? I found Webmin, but it seems limited. Is there an HTML GUI for MySQL? Check out MysqlTool at ... http://dajoba.com/projects/mysqltool/ ... it's a web-based interface implemented in Perl. If you prefer one written in PHP, have a look at phpMyAdmin at ... http://phpwizard.net/projects/phpMyAdmin/ - Ray - 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