| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
Comments:
<0> :(
<1> i'm too ***y for my sql. I'm too ***y for m y sql.
<2> use access ;)
<3> o/ hello
<4> so does anyone know a good tool to design database
<4> s?
<1> phpmyadmin?
<3> maybe someone here can help me. I am flying by the seat of my pants trying to get php running w/mysql ... errors I get are this: http://www.rafb.net/paste/results/f86QiS61.html
<1> !m Stronith old client
<5> Stronith: (Client does not support authentication protocol) : http://dev.mysql.com/doc/mysql/en/Old_client.html
<1> Got shell access to the server?
<4> TGoC, to basic. I mean something with a GUI and some kind of ERD-like interface
<1> SWAT... phpmyadmin is probably the best you are going to get.
<1> I doubt there is a GUI for and if there is it most likely won't be free
<4> TGoC, :-/ thanks for your input
<3> I'd be more than happy to use PHP 5.x but it does not come packaged with mySQL support ... and i'm not experienced enough to set it up, even with the step by steps i found, can't seem to get it to work...
<4> I know PowerDesigner, but's it's way too expensive
<1> Stronith do you have shell access and are you able to use apt-get ?
<3> see, i am not sure what that means either >.>
<3> probably do *shrug*
<1> hold on
<3> shell access .. to mysql>
<1> when your in shell, type: apt-get
<1> and tell me what the output is Stronith
<1> Like i said SWAT. Anyway i like mysql the way it is and the way it got designed. No need for a GUI simply because phpmyadmin and mysql clients should do.
<3> i broke something TGoC ... happened once before and a reboot fixed it. brb
<4> TGoC, thanks
<3> TGoC - yea I broke mySQL .. ^.^ access denied for user 'root'@'localhost' (using p***word: No) ... can you help?
<1> sure Stronith
<1> It is working now
<1> By the way
<1> PLEASE i beg you, not to use root
<3> no
<1> with working i referred to the mysqlclient
<1> Stronith add a new user, give it access to the database('s) that required
<3> pretend I know nothing of mysql, but absolutly need this to work, kay? I've learned 100 different wayys to tinker with it and now I am all confused
<1> lol
<3> I have the MySQL Administrator program
<3> will that help?
<1> with administrator program, what exact program are you referring to? phpmyadmin?
<3> that's what it's called.
<3> MySQL Administrator
<1> Ok, let me look that up first.
<1> ahh
<3> sure thing. I've been at this like 6 hrs now....so i can wait a few
<1> SWAT... in case you are still looking for the GUI -> http://www.mysql.com/products/tools/administrator/
<1> Ok
<1> and when you are using this, you are getting access denied and are 100% positive that your login information is correct?
<4> TGoC, thanks
<1> SWAT thank google
<3> lol. kay so i set a p***word ... i'm at mysql> now
<1> Stronith can you be more specific about what's not working and what is?
<3> that's the shell, right? so type what?
<1> uhm let me see
<1> !grant
<1> !access
<3> ?? TGoC - you said to type a command at the shell and tell you what it said..?
<3> I'm at a mysql prompt now, in the right place?
<1> that's the mysql shell, i need a shell to the machine your mysql is running on
<1> but you don't need that anymore since your mysql client error is gone right?
<1> Ok, lets keep it to 1 thing at a time before i totally make you confused.
<1> You have that mysql administrator tool and you can use it without any problem?
<1> Second question: are you running the database on the computer you are on right now and if so are you root of the machine?
<3> lol...i can use it. i seem to create problems with it though
<3> yes, on this computer
<1> ok
<1> The paste you gave me is php output?
<1> And at the moment it is only giving Access denied for root?
<1> no errors about incorrect mysql clients or anything?
<3> sorry, should have updated you more clearly
<3> the access denied thing was an unexpected thing that came up, that is fixed. (just took away the pswd i set in the admin program)
<1> Ahh ok
<3> the issue i have is the original problem...with PHP and my mysql
<1> inform me your current problem
<1> cause i lost it
<1> :p
<3> http://www.rafb.net/paste/results/ScYN4Z60.html
<3> that is the errors i get when attempting to run a front-end written in PHP
<3> *those are ..
<3> :)
<1> ok
<1> what Operating system are you running on?
<3> XP, IIS 5, PHP 4.4, mySQL 5 .... brb, 4 min
<3> XP Pro
<1> ahhh, ok
<1> Did you do the with or without mysql support installation?
<1> If your not sure: http://www.php.net/get/php-4.4.2-installer.exe/from/a/mirror
<3> <back>
<6> i need some help building mod_auth_mysql with base64 p***word encoding, can anyone point me in the right direction?
<6> or rather base64 p***word support
<1> Stronith Did you do the with or without mysql support installation?
<3> TGoC .. yes, i DL the one that says "(CGI only, MySQL support built-in, packaged as Windows "
<1> kz
<1> mind upgrading to php 5
<1> ?:p
<1> Cause mysql and php on win platforms is not my expertise
<3> if you can walk me through adding mysql to it. i have tried numerous times and ways to do it ...
<3> because it doe not come installed
<7> can i have mysql show slow queries without activating the log feature?
<1> what's wrong with log feature lorfds
<3> AFK for few more minutes... be right back
<1> Well
<1> i am going to bed now
<8> damn (!!!)
<1> Ask someone else, later :)
<8> mysql gone away again
<9> how do i create a new mysql user in command promt - i never get it right when reading from dev.mysql
<9> anyone got a simple tut for this
<7> GRANT PRIVILEGES
<9> ?
<7> GRANT PRIVILEGES ON testdb.* TO 'testuser'@'localhost' IDENTIFIED BY 'p***word';
<7> make sense?
<9> not for a specific database but mysql
<7> well, what do you want the user to be able to do?
<7> change everything?
<7> and actually I messed up -- you want GRANT ALL PRIVILEGES
<9> create-delete etc
<9> tis on my local machine
<7> so there should be nothing that the user can't do
<7> anything from creating new users, to creating new databases, to deleting users and deleting databases
<7> by the way, do you have phpmyadmin? -- it is a lot easier to do in that if you have it
<7> if that is what you want, then you want GRANT ALL PRIVILEGES ON *.*
<7> and then they can modify anything they want
<10> Can someone point me to a resource on how to use UNIQUE?
<9> lorfds i stil havent got this right with these only examples
<9> idid this a while back to me it was just three steps
<9> mysql username=pasword smething i gues si cant remember
<11> guys, lets say i have 2 tables that almost look alike, the only difference is that on the 2nd table i have 2 extra fields, is there any sql statement or whatever that will allow me to copy 1 record from table #1 to table #2 and specify what the values are for those remaining 2 extra values
<12> Apr 6 17:09:35 mailhost01 authdaemond: vmysql: sql error[3]: MySQL server has gone away
<12> it seems mysql is on tho
<13> !man gone away
<5> (MySQL server has gone away) : http://dev.mysql.com/doc/mysql/en/Gone_away.html
<12> archivist: BUT: it just started happening, and the timeout was never changed in my.cnf
<7> how do i activate the slow query log?
<12> archivist: innodb_lock_wait_timeout = 50
<12> is that okay?
<13> dunno you could try changing it
<13> lordfs enable it in my.cnf
<7> where might one find that file
<12> /etc/mysql/my.cnf
<13> /etc
<13> !man slow query log
<12> archivist: i fixed it, thanks
<14> how do I check if date is valid ?
<14> like not 0000-00-00
<15> how can i from console connect to a http site and dl file x ?
<16> wget
<15> i know its not sql but the file is to be imported to mysql
<14> or dcol='0000-00-00' will do ?
<16> heh
Return to
#mysql
or
Go to some related
logs:
ubuntu drmOpen failed
hid create error 2
kuickshow xgl trouble
#gentoo
debian bf26
ubuntu mp3 gnomebaker
installing xplanet on ubuntu
Warning: Cannot find word list en.latin1.spl or en.ascii.spl
debian linux-image for dell latitude c600
tcltls dependency problems
|
|