| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9
Comments:
<0> book being clumsy?
<1> can someone help me? i deleted an sql user from an sql database using cpanel on accident, now my forum is messed up, i put the user back in place with the same p***word, but it's still not working. I keep getting this... SQL error: Access denied for user: 'guidex_phpbb2@localhost' (Using p***word: <removed>)
<2> the p***word in the sql table is hashed
<0> you need to fuch the priviledge table perhaps?
<0> flush
<2> if you're entering directly into the table, you need to insert the hash of the user's p***word; not the p***word's directly
<1> i'm not entering with the table i used cpanel to remove and to add again
<1> i'll flush the privledge table thanks
<3> I got problems with adding SSL to my mysqld, when I change the my.cfg to add in the ssl-key, ssl-cert and ssl-ca it won't start again
<4> how do i create a db
<4> it says it can't connect to the 'localhost'
<4> but i have the server running
<4> can someone help me?
<4> mysqladmin.exe: connect to server at 'localhost' failed
<4> error: 'Access denied for user 'ODBC'@'localhost' (using p***word: NO)'
<3> well user and p***word correct ?
<4> yes
<1> i have the same prob asdx
<4> really?
<1> yeah with sql/cpanel/invision power board
<1> wont log in :(
<4> i can log in
<4> with the shortcut thing
<4> but i need to create a db with mysqladmin
<4> and log in with that db
<4> then dump that db
<1> mine is already created, i deleted the user and recreated it and linked it back to the db but the forum still wont access it
<1> keeps saying SQL error: Access denied for user: 'guidex_phpbb2@localhost'
<4> how do you created the db
<1> it was created by my forum software
<1> i used cpanel to remove/add the user
<1> i accidentally deleted my sql user today
<1> and recreated with cpanel
<1> and now forum has problems
<5> hey
<5> how can i split sql file into many small files that phpmyadmin will accept?
<6> hi
<5> hey anyone get my question?
<7> use the split command
<8> Sashi: If you need to break it up, do it logically. Use mysqldump, if possible. If you have an sql file, you might have to do it manually or with tools like gawk.
<7> or gnu split
<8> Split will be a problem, since many statements can involve multiple lines.
<8> gawk and friends can handle that sort of thing.
<9> !man indexes
<10> (Column Indexes) : http://dev.mysql.com/doc/mysql/en/Indexes.html
<11> is there a sql query I can use to get the next int of an autoincrimenting int?
<12> Nam, usually would be SELECT MAX(int_field)+1 FROM table_name
<11> hmm... would that not cause problems if say... the next id is 2001, but 2000 was deleted, wouldn't that statement then grab the wrong next int?
<12> true
<12> i think there's a function for this, actually
<11> because if 1999 is still in the db, that is the max, so that query would return 2000 not 2001 which is the true next id
<13> In a somewhat related question, is there a way to 'condense' down a table with deleted rows on an autoincrementing ID so there are no more gaps ? other then creating a temporary table, and iterating through the entire thing, moving rows to the new one, and then replacing the old table ?
<14> why would you want to do that ?
<13> Annoying, unchangeable client side code.
<14> in that case your best bet is probably to create another auto_increment table, insert all the rows into that, together with the current id, change all references to the original id in other tables to the new one, truncate the original table, then reinsert the data
<13> pretty much what i figured i'd have to do.
<14> or you could insert some filler data
<14> into the gaps i mean
<13> wouldnt work. program is an image viewer that hardcodes the prev and next to ID-- and ID++.
<13> I didnt have high hopes, jsut figured it was worth asking.
<14> you could always rename the table and then create a view of it with contiguous id
<14> lol
<14> i meant ids that follow sequentially
<13> oh, i get the idea.. i jsut dont have a clue how one would perform that feat.
<9> does MyISAM 4.1 support foreign key constraints in 4.1?
<11> is there a sql query I can use to get the next int of an autoincrimenting int?
<15> Nam, take a look at the LAST_INSERT_ID() function.
<16> hi I got a doubt
<16> I got mysql 4.1
<16> I foudn out that the function about mysql_create_db() is disable
<16> is there any faq regarding this
<17> hello, when i type "mysql" into terminal...I get this: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
<17> any suggestions?
<16> cgl: your mysql server is not running
<17> how do i start it?
<18> JZA, mysql_query ("create database ...");
<16> which distro of linux do you run
<16> bobfield: yes I saw that on a php note to use mysql_query
<17> i'm on mac os x
<16> however is there a reason why the function was disabled?
<18> supefluous since you can use mysql_query
<16> cgl: I see, well you need to start it somewhere around the services, I dunno OSX so my unix guess is that it will be on something like /etc/rc.d/mysqld
<18> and plus calling mysql_query you have many more options
<16> bobfield: right, but then again thats the same case with mysql_select_db etc...
<17> I get a weird permissions denied...i'm the administrator!
<16> are you root?
<17> no
<17> i did this before and i wasn't root
<16> well then you are NOT the administrator and you shouldnt
<16> > su
<16> > p***word: ******
<16> > /etc/rc.d/mysqld start
<16> now type exit and then do mysql -u root
<17> yea, that makes sense
<17> but i did this before and i wasn't root
<17> and i don't have the root pw
<17> now it's complaining...
<16> then you probably was sudo
<17> what's sudo
<18> one-shot su
<17> what's the command "sudo -v"?
<16> sudo is something that allows you to run as regular user (what you are)
<16> system commands
<16> cgl: the other reason that it work before might have been because mysqld was already running
<17> so....i do a "sudo ./bin/mysqld_safe
<18> sudo -v validate the timestamp and resets the sudo timeout
<16> yeah that might work
<17> i still get permission denied when i try to run "./bin/mysqld_safe"
<17> permission denied on the "data" folder
<16> did u put sudo?
<16> cgl: is this your machine, you should know the root p***word
<16> you need it for every program you want to install
<16> even widgets
<16> afaik
<17> i think this may be a mac os x issue
<17> i'm basically running into this issue: http://www.webmasterworld.com/forum49/328.htm
<18> didn't I hear something about macos not allowing direct access to root or even su?
<14> actually lots of programs can be installed as a user so long as you install them into somewhere in the user's home directory
<16> right
<16> however you still should be able to be root
<16> if you have the p***word
<14> yup
<14> could always boot from an install cd and reset the root p***word :P
<19> i am having problems logging into mysql
<19> Enter p***word:
<19> mysqladmin: connect to server at 'localhost' failed
<19> error: 'Access denied for user 'db_user'@'localhost' (using p***word: YES)'
<16> check your mysql table
<16> it usually have your user data
<17> ok, i'm going to try the solution as posted here....this is exactly my problem: http://blog.johnjosephbachir.org/index.php?p=122
<18> someone was just posting in the forums about permission problems with \tmp
<18> don't remember what os
<16> bobfield: he said it was G5 so I guess is OSX
<17> ok, here's the magic command for others reference: sudo bin/mysqld_safe -user=mysql -log
<16> cgl: great
<17> there's an explanation of it in the comments if you care to read
<17> yea, i'm new to mac os x AND mysql...so i'm literally running in the dark w/ scissors
<18> The one I was thinking was Fedora actually
<20> Can this be done?: I'd like to retrieve on a single line what normally you'd retrieve on multiple lines and then combine in an array in PHP or whatever.
<20> Example: Three tables [cd: cd_id, cd_title], [song: song_id, song_title], [junx: cd_id, song_id, sequence], ***uming all CDs have three and only three songs
<20> I'd like the result to be: "cd_title, song1_title, song2_title, song3_title" rather than three lines of "cd_title, song_title"
<18> pege, use group_concat()
<18> !m peqe grouping functions
<10> peqe: (Parentheses) : http://dev.mysql.com/doc/mysql/en/Parentheses.html
<18> bah
<18> !m peqe group functions
<10> peqe: (GROUP BY (Aggregate) Functions) : http://dev.mysql.com/doc/mysql/en/GROUP-BY-Functions.html
<18> that's better
<20> SQL, bobfield: Thanks, I'll study up on it!
<18> np
Return to
#mysql
or
Go to some related
logs:
#perl
#gaim
do_syncrep1: rid ldap_sasl_bind_s failed (-1)
xorg xhosts
socket fromfd python windows
starting hal daemon hangs
#nvidia
quotesdb.info/freenode/php/08Feb2006/18.html
gentoo unknown host ifconfig
#debian
|
|