se1zure Posted January 22, 2007 Share Posted January 22, 2007 I decided to try out using mysql with php.I have mysl on my server, and I login, and create a new user. (the pic below shows the steps I follow). Using username = cory, and pw = 123456.[URL=http://allyoucanupload.webshots.com/v/2005256806995396933][IMG]http://aycu17.webshots.com/image/10136/2005256806995396933_rs.jpg[/img][/URL][code]<?php$con = mysql_connect("localhost","se1zure_cory","123456");if (!$con) { die('Could not connect: ' . mysql_error()); }// Create databaseif (mysql_query("CREATE DATABASE se1zure_postdata",$con)) { echo "Database created"; }else { echo "Error creating database: " . mysql_error(); }// Create table in se1zure_postdata databasemysql_select_db("se1zure_postdata", $con);$sql = "CREATE TABLE Person (FirstName varchar(15),LastName varchar(15),Age int)";mysql_query($sql,$con);mysql_close($con);?>[/code]That is the code I am using to create a new database, and add a new table to it.THis is the error I get, can you tell me what i am doing wrong?[code]Error creating database: Access denied for user 'se1zure_cory'@'localhost' to database 'se1zure_postdata'[/code][attachment deleted by admin] Link to comment https://forums.phpfreaks.com/topic/35155-problem-connecting-to-mysql-through-php/ Share on other sites More sharing options...
se1zure Posted January 22, 2007 Author Share Posted January 22, 2007 bump, can anyone help? Link to comment https://forums.phpfreaks.com/topic/35155-problem-connecting-to-mysql-through-php/#findComment-166036 Share on other sites More sharing options...
smc Posted January 22, 2007 Share Posted January 22, 2007 Edit:Your not able to connect to the database since you have no user assigned to it since it's not created in the first place. It's an unfortunate loopWhat you need to do is create the database in cPanel and then you can add tables to it.Your problem is your trying to connect to a database that doesn't exist, when creating a user in cPanel it is nothing until it is associated with a database.You *MIGHT* be able to do what you want by using your root cPanel username and password to attempt to login Link to comment https://forums.phpfreaks.com/topic/35155-problem-connecting-to-mysql-through-php/#findComment-166040 Share on other sites More sharing options...
se1zure Posted January 22, 2007 Author Share Posted January 22, 2007 php is able to create databases, I thought? Link to comment https://forums.phpfreaks.com/topic/35155-problem-connecting-to-mysql-through-php/#findComment-166049 Share on other sites More sharing options...
smc Posted January 22, 2007 Share Posted January 22, 2007 It is, but not if you cannot login to it. Please read the entirety of my post Link to comment https://forums.phpfreaks.com/topic/35155-problem-connecting-to-mysql-through-php/#findComment-166050 Share on other sites More sharing options...
Nhoj Posted January 22, 2007 Share Posted January 22, 2007 Those screenshots LOOK like they came from cPanel, if that's the case. Use your cPanel information as your mySQL user information.cPanel Username = mySQL usernamecPanel Passoword = mySQL password Link to comment https://forums.phpfreaks.com/topic/35155-problem-connecting-to-mysql-through-php/#findComment-166091 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.