Re: First question: a howto.
At 10:12 -0600 9/11/02, [EMAIL PROTECTED] wrote: >I can't add a new user or I don't know the proper way to log into the >server. I added a user; call him webley. Ran my sql statement to insert into >the user and db tables. Granted all rights because I was unsure how many >rights my cgi script would need. It does need to create new tables and >populate data. when I try to log in as that user, "mysql -u webley -p >icesql" I get the prompt for a password but after entering I get "access >denied". The "icesql" is in the db table and webley does have rights in the >db table for that database. Can someone tell me if I am missing the big >flick? If you used INSERT, did you also FLUSH PRIVILEGES after creating the grant table entries? Generally, it's better to use GRANT, which is easier, and also causes the server to reread the grant tables automatically. > >Brian Duke >CTIP/TNT CFP IPSA >Level(3) Communication >(720) 888-7797 >==-=-=-=-=--==--==¬ - 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
First question: a howto.
I can't add a new user or I don't know the proper way to log into the server. I added a user; call him webley. Ran my sql statement to insert into the user and db tables. Granted all rights because I was unsure how many rights my cgi script would need. It does need to create new tables and populate data. when I try to log in as that user, "mysql -u webley -p icesql" I get the prompt for a password but after entering I get "access denied". The "icesql" is in the db table and webley does have rights in the db table for that database. Can someone tell me if I am missing the big flick? Brian Duke CTIP/TNT CFP IPSA Level(3) Communication (720) 888-7797 ==-=-=-=-=--==--==¬ - 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
First Question
Dennis, Tuesday, March 26, 2002, 2:12:43 PM, you wrote: DP> My boss told me I have three days of time to develop a php-website that DP> is capable to handle SQL-Requests into a database. DP> Problem is I don't have any experiences. DP> Now I have startet with compiling Apache with PHP support and installing DP> the MySQL package which comes with SUSE 7.3. DP> I logged into MySQL with ./usr/local/mysql/mysql DP> but I don't know how to start. I got a manual which starts when I have DP> already some tables. But I don't have a database yet. DP> How do I create. DP> Thank you in advance and I am very sorry about these kind of questions, DP> but I will get better. To start MySQL server you should run safe_mysqld & You can read more about starting MySQL server at: http://www.mysql.com/doc/A/u/Automatic_start.html If you have MySQL server running you can create databases. You can use CREATE DATABASE statement or mysqladmin utility. You can read about CREATE DATABASE at: http://www.mysql.com/doc/C/R/CREATE_DATABASE.html About mysqladmin at: http://www.mysql.com/doc/m/y/mysqladmin.html Info about MySQL privilege system will also be useful for you, look at: http://www.mysql.com/doc/P/r/Privileges_options.html http://www.mysql.com/doc/P/r/Privileges.html http://www.mysql.com/doc/G/R/GRANT.html http://www.mysql.com/doc/D/e/Default_privileges.html DP> dcp -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - 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
First Question
Hi I am new to the list My boss told me I have three days of time to develop a php-website that is capable to handle SQL-Requests into a database. Problem is I don't have any experiences. Now I have startet with compiling Apache with PHP support and installing the MySQL package which comes with SUSE 7.3. I logged into MySQL with ./usr/local/mysql/mysql but I don't know how to start. I got a manual which starts when I have already some tables. But I don't have a database yet. How do I create. Thank you in advance and I am very sorry about these kind of questions, but I will get better. dcp - 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
First Question
This is my first question to the list. Anybody know of a condensed index/glossary of SQL keywords that MySQL ver. 3.22.19 uses? Neo-Genus Multimedia Studios Boyd White Database Engineer [EMAIL PROTECTED] (903)731-9644 - 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