Newbie Spellweaver
- Joined
- Sep 8, 2013
- Messages
- 49
- Reaction score
- 1
Connect failed: Access denied for user 'root'@'10.2.1.45' (using password: YES)
I'm trying to put SQL details but it's not working for me.
Any help?...
Edit:
That's the specific error I get, I am using root password for SQL to prevent hackers.
Browse to source/assets/config/database.php and change the DB credentials to yours. If you have the correct credentials and have a mysqld service running, it should connect just fine.
//SQL Information
$host['hostname'] = 'localhost'; // Hostname [Usually locahost]
$host['user'] = 'root'; // Database Username [Usually root]
$host['password'] = '123456'; // Database Password [Leave blank if unsure]
$host['database'] = 'mapleblade'; // Database Name
Alright, that's what there
How can I know what's my database name, expect that I filld everything exactly like mine and put it back into the host and still same.
Don't directly edit the config files. You need to know what your database name is lol
How can I know what my database name is? I am really sorry, I barely know about SQL.
I know the username, password (I got one, I'm sure). But I have no clue about the database name, where can I see it?
It's the schema name.
Then that's exactly what I'm doing.
Look over here:
You must be registered to see links
And that's the error I get:
You must be registered to see links
Thanks for this will use this for my first private server!
uh i need some help haha,
ive added the files to my Wamp ( localhost www folder )
i installed it and its working fine.
now i need others to see my website aswell?
i am using no-ip as a DNS
but, nobody can connect as i noticed i didnt had to fill in a single IP adress except for where my database is connected ( wich is 127.0.01 ) or do i need to change that to my own IP adress >?
yeah i ndid that straight after i posted here i forgot to change it here hahaThis doesn't have to do with the website. The localhost/127.0.0.1 for your database is fine and doesn't affect your users in anyway.
You have to portforward port 80 (and the server ports as well). Go to the Help section and ask if you need any further help with portforwarding.
Hello, I'm hoping someone could help me. I've been trying to set up a private server. I was successful with a 142 build, but it was incomplete, so i'm trying to downgrade to a 117 source. Trouble is, for some reason MapleBit isn't writing to my database, meaning I can't login to MapleBit or Maplestory because the "account" table isn't being written to. All the server login stuff is just fine, accessing the base is not a problem. It's just writing that's the problem.
I've tried dropping and re-creating the database, re-installing WAMP (my server program), MapleBit, etc... From what I can tell, everything is fine, but the maple-related stuff just can't edit the database (or schema if you will).
I would appreciate any help you folks can give me.
Check your mysql permissions. Make sure the mysql user/pass that your site is connecting to the database with can WRITE to the database under the Management section in Workbench.
Make sure nothing is blocking proper connections to your database as well. Check your antivirus (I'm grasping for straws here, but some of these can do just a tad too much when protecting you).
If you're positive about that, check to make sure that PHP or MySQL isn't experiencing any errors. Remove/comment out error_reporting if you have it and report any errors. Check any error logs as well.
Unfortunately, your suggestions didn't work, and I'm not sure where to look for error_reporting. What bothers me is that the problem appeared suddenly, though the database was updating just fine for a while. Something might have broken along the way with my tinkering, but surely the reinstalling I did would have wiped the slate.
<?php
error_reporting(E_ALL);
// Database Configuration
$host['hostname'] = 'localhost';
$host['user'] = 'root';
$host['password'] = '';
$host['database'] = 'databasename';
$db = new PDO("mysql:host=".$host['hostname'].";dbname=".$host['database']."", $host['user'], $host['password']);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// Test
try {
$query = $db->prepare("INSERT INTO accounts (name, password) VALUES (:name, :pass)");
$query->bindParam(':name', $name);
$query->bindParam(':pass', $pass);
$name = md5(rand(1,665)+strtotime(date('curr_date')));
$pass = md5(rand(666,999)+strtotime(date('curr_date')));
$query->execute();
} catch(PDOException $exception) {
echo $exception->getMessage();
}
?>
The MapleBit registration script doesn't input a birthday and banned time into the respective columns. Depending on the sql script used to generate the database tables, it'll put a default into the fields. If the script has all zeros as default, MySQL will return an error and refuse to input anything. The solution is to put a valid date as default for both 'birthday' and 'tempban,' or add a birthday field to the MapleBit registration page. This "date" problem applies to any sql table, it'll do nothing if it finds all zeros. Make sure to check your scripts and put a valid date as any "default" settings.
i can't find forgot password page? MapleBit not have forgot.php page?