Mysql Database Restore Problem Need help ASAP

[-Sky- 0]

Error

 

SQL query:

 

--

-- Database: `gtasforums`

--

CREATE DATABASE `gtasforums` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

 

MySQL said: Documentation

#1044 - Access denied for user 'tgtasect'@'localhost' to database 'gtasforums'

I don't know what's wrong, but this is the exact error I keep getting.

 

Please help.

[anwiii 17]

i had some free time so i googled it. these guys seemed to fix the problem you are having. follow the link. hope it makes sense to ya. half of what they were saying didn't to me

http://forums.xisto.com/no_longer_exists/

also, have a look at this. directly from the mysql website....

http://dev.mysql.com/doc/refman/5.7/en/access-denied.html

I don't know what's wrong, but this is the exact error I keep getting.
Please help.

[-Sky- 0]

I am trying to import the backup of my .SQL file. These are the errors I keep getting.I need help guys.

[Soviet Rathe 1]

I never got mine working, but I figured I didn't really need it.but it would be good to get my old forum running so I could use some of it's stuffas far as i know it's the SQL version.. xisto's version is out of date.. because the version on my free host was newer then the one xisto has so idk you might send a ticket and see what they say.

[jlhaslip 4]

Sky, The SQL cluster here at the Xisto requires that the DB name is a combination of your user_name and the DB name. For example, my Cpanel user_name is "jlhaslip" and the Database name is "aef108" so when the SQL command hits the MySql server, the database name should be "jlhaslip_aef108". No quotes, of course, and notice the underscore joining the user name and dbname???Also, there is a maximum length of 8 characters (I think) for the DBname portion of the combination. ie: jlhaslip_12345678So you may need to adjust your DB name in the SQL and the Config file to suit. What package are you installing? Does it ask for the DBname in a config file? It likely requires a User_name, a DB_name, a password, and the Server_name. The Server_name for Xisto is "localhost"

[-Sky- 0]

@ haslip: PM Sent to see if you can help me.

[jlhaslip 4]

received your PM, but am having some computer issues. I think it needs to cool down some before I can load that file into the editor. Give me a couple minutes here.

[k_nitin_r 8]

@SkyHi!I think what you are experiencing is a privileges issue. I'm guessing that your web hosting provider does not permit you to run CREATE DATABASE statements from within the interface that you are using. They provide a separate web utility for creating databases and you can then use the utility you are currently working with for executing ad hoc queries.If you are still unable to resolve the issue, PM me and I'll see if I can help.

[-Sky- 0]

I'd like to give a big thanks to those who have helped me, and those who have offered to help me! All of your efforts in which to help me get this issue fixed is much appreciated.However, now I need to know how to change a username's password via MySQL command lines. :)Thanks.

[shadowx 0]

What password are we talking about here, the password of a user? (eg i joined your site but now i need to change my password)Or the password for you, as an SQL admin? (Eg, you, the owner of the SQL databases needs to change the password for the phpmyadmin login)

[-Sky- 0]

Thanks for your reply shadow.I need help changing a user password IN phpMyAdmin. My old GTA forum is IPB 2.3.5 so I reuploaded a fresh copy of IP.Board 2.3.5 off my backup disk along with other stuff I had for my board, my IPB license etc. However, the DB is done and all etc etc etc, now I need to install some mods for my forum index to show again (because it's a fresh copy of 2.3.5 most of my files I had have gone. So now I need to change my user password via phpMyAdmin.Thanks.

[shadowx 0]

well you dont need to use SQL code to do it, im not sure if thats possible, but i suppose it is...To change it here at T17 you need to go into the Databases tool where you first went to create a database, and then into privileges or users. Im a bit rusty but it should be along those lines. Then select the user and there should be an option to change the password there. If not you could just delete the user and remake it with the new password.

[-Sky- 0]

No no, you don't understand. I am not trying to change passwords for my Trap hosting account stuff. This is for my FORUMS database. My forum runs an eairly version of IP.Board 2.3.5 (because I uploaded a backup) and I have forgotten that password to my Admin account. I need to know how to change a users password in the IPB tables of ibf_members or ibf_converge_members.

[shadowx 0]

oh ok, im with ya!

First of all you need to find out what encryption method they use for the older forums, you can trawl through their PHP code and look for terms like "md5" or you can take a guess...

Basically go into your phpmyadmin, go to the forum table and look for one called, or similar to, "users" once you have found that you should see all the usernames of the members, go to the account you want to modify and then there should be a "password" or similar, box. In there will be some encrypted text, assuming it is md5 what you need to do it find a free md5 generator like this one and type in your new password in there and hit the button to make a nice md5 string. Copy/paste that into the password box in phpmyadmin and save the changes, then try logging into the forum.

If it doesnt work then these are the possible problems:
1)you updated the wrong table/record, double check it
2) we are using the wrong hash or encryption. another method is to go to the forum register page, make a new account with a useless username like "skytestletmein" so you can spot it easily, and set its password as YOUR new password (the one you want for the admin account) now go back to phpmyadmin, find that user, find the password field and copy the text from it and paste into the admin's password field in phpmyadmin. or you can try and find the correct hash/encryption method and try again
3) You typed the password wrongly in the hash generator. double check it and try again.



That should do the trick though provided you update the correct field.

[-Sky- 0]

Shadow, do you have any MSN sort of program? It'd be easier then posting.The hash is MD5, and there is no such variable called "Password". There's only "converge_pass_hash" and "converge_pass_salt".