distal-attribute
distal-attribute
distal-attribute
distal-attribute

Creating new Database with setting own system as host

User, date Message
Written by saurabh
6 months ago
Category: Creating a connection
3 posts since Sat, 05 Oct 13
Hi,
I want to create a new database as my system is host.
Now, I am using a database but it is hosted to another system.
When I am trying to create a database it shown SQL ERROR(1045)
The main reason is, the database which is used by me is created on another system as host and now That person is not available to told us password.
Can I use another password to create my own database as my system would be host and this password will not affected the main Host database.
Since, I am new user so, i have no more Idea about this one.


Please help me, Thanks in Advance.....
Written by ansgar
6 months ago
4793 posts since Fri, 07 Apr 06
So you do not have the privilege to create databases, and there is noone else to do that, right?

Do you have access to the server, so you could stop and restart the server with the "--skip-grant-tables" parameter? If yes, you can login with any user/pass and create a user with appropriate provileges.
Written by saurabh
6 months ago
3 posts since Sat, 05 Oct 13
Yes, I have access to server,
But I am fresher. so I am not sure about some thing
Something else......
Written by ansgar
6 months ago
4793 posts since Fri, 07 Apr 06
Does the MySQL server run on a Windows computer?

If so, do this:
* Click Start > Run, type "cmd.exe"
* Type "net stop mysql" /Enter
* Type "c:\program files\mysql\bin\mysqld --skip-grant-tables" /Enter (Be sure to use the right path)
* Log into MySQL per HeidiSQL, using any user/password
* Click Tools > User manager, and adjust your own privileges
* Log out
* Type "Ctrl+C" into the console window, to stop the mysql server
* Type "net start mysql" to start the server again in normal mode
Written by saurabh
6 months ago
3 posts since Sat, 05 Oct 13
Thanks....
 

Please login to leave a reply, or register at first.