Group,
I'm using ver 5 with winXP. I can access the test database, but can't create
a table. I can't create ANY database as I keep getting error 1044 (42000):
Access denied for user: ' '@'localhost' to database 'mynewdatabase'. Can you
help?
TIA,
Wade 8 12411
W.Davis wrote: Group, I'm using ver 5 with winXP. I can access the test database, but can't create a table. I can't create ANY database as I keep getting error 1044 (42000): Access denied for user: ' '@'localhost' to database 'mynewdatabase'. Can you help?
Log in as root user. I assume you are currently logged in as test user
(test user has no access to create databases).
If you are using mysql console program, and you have not set up a
password for root user, you can log in as root like this:
mysql -u root
W.Davis wrote: Group, I'm using ver 5 with winXP. I can access the test database, but can't create a table. I can't create ANY database as I keep getting error 1044 (42000): Access denied for user: ' '@'localhost' to database 'mynewdatabase'. Can you help?
Log in as root user. I assume you are currently logged in as test user
(test user has no access to create databases).
If you are using mysql console program, and you have not set up a
password for root user, you can log in as root like this:
mysql -u root
Still doesn't work! The only thing I can work with is the test database. I
can't create at all. Also, along with this problem, I can't use the source
command from the console program, it keeps giving me the error that 'table
mysql.proc doesn't exist'. I tried running mysql_fix_privileges, but it
won't run either. I'm on a WinXP box and using version 5.
Wade
"Aggro" <sp**********@yahoo.com> wrote in message
news:sl*************@read3.inet.fi... W.Davis wrote:
Group, I'm using ver 5 with winXP. I can access the test database, but can't
create a table. I can't create ANY database as I keep getting error 1044
(42000): Access denied for user: ' '@'localhost' to database 'mynewdatabase'. Can
you help?
Log in as root user. I assume you are currently logged in as test user (test user has no access to create databases).
If you are using mysql console program, and you have not set up a password for root user, you can log in as root like this:
mysql -u root
Still doesn't work! The only thing I can work with is the test database. I
can't create at all. Also, along with this problem, I can't use the source
command from the console program, it keeps giving me the error that 'table
mysql.proc doesn't exist'. I tried running mysql_fix_privileges, but it
won't run either. I'm on a WinXP box and using version 5.
Wade
"Aggro" <sp**********@yahoo.com> wrote in message
news:sl*************@read3.inet.fi... W.Davis wrote:
Group, I'm using ver 5 with winXP. I can access the test database, but can't
create a table. I can't create ANY database as I keep getting error 1044
(42000): Access denied for user: ' '@'localhost' to database 'mynewdatabase'. Can
you help?
Log in as root user. I assume you are currently logged in as test user (test user has no access to create databases).
If you are using mysql console program, and you have not set up a password for root user, you can log in as root like this:
mysql -u root
Got some of it. I can now create database. However, I cannot use the source
command to create my tables. In earlier versions I could do this. What I was
doing wrong was I was not using the console PROGRAM.... I was only typing
commands into the WI NDOWS cmd console. But... still the biggest problem is
not being able to get source command to work.
Wade
"Aggro" <sp**********@yahoo.com> wrote in message
news:sl*************@read3.inet.fi... W.Davis wrote:
Group, I'm using ver 5 with winXP. I can access the test database, but can't
create a table. I can't create ANY database as I keep getting error 1044
(42000): Access denied for user: ' '@'localhost' to database 'mynewdatabase'. Can
you help?
Log in as root user. I assume you are currently logged in as test user (test user has no access to create databases).
If you are using mysql console program, and you have not set up a password for root user, you can log in as root like this:
mysql -u root
Got some of it. I can now create database. However, I cannot use the source
command to create my tables. In earlier versions I could do this. What I was
doing wrong was I was not using the console PROGRAM.... I was only typing
commands into the WI NDOWS cmd console. But... still the biggest problem is
not being able to get source command to work.
Wade
"Aggro" <sp**********@yahoo.com> wrote in message
news:sl*************@read3.inet.fi... W.Davis wrote:
Group, I'm using ver 5 with winXP. I can access the test database, but can't
create a table. I can't create ANY database as I keep getting error 1044
(42000): Access denied for user: ' '@'localhost' to database 'mynewdatabase'. Can
you help?
Log in as root user. I assume you are currently logged in as test user (test user has no access to create databases).
If you are using mysql console program, and you have not set up a password for root user, you can log in as root like this:
mysql -u root
Now isn't this wierd.... since I keep getting the error "1146 table
mysql.proc does not exist" when I try to run the source command, I said
'what the hell' and I entered "create table proc (id char(1))" after opening
the mysql database, and for some reason, I can NOW run the source command.
Explain that one if you can.
Wade
"Aggro" <sp**********@yahoo.com> wrote in message
news:sl*************@read3.inet.fi... W.Davis wrote:
Group, I'm using ver 5 with winXP. I can access the test database, but can't
create a table. I can't create ANY database as I keep getting error 1044
(42000): Access denied for user: ' '@'localhost' to database 'mynewdatabase'. Can
you help?
Log in as root user. I assume you are currently logged in as test user (test user has no access to create databases).
If you are using mysql console program, and you have not set up a password for root user, you can log in as root like this:
mysql -u root
Now isn't this wierd.... since I keep getting the error "1146 table
mysql.proc does not exist" when I try to run the source command, I said
'what the hell' and I entered "create table proc (id char(1))" after opening
the mysql database, and for some reason, I can NOW run the source command.
Explain that one if you can.
Wade
"Aggro" <sp**********@yahoo.com> wrote in message
news:sl*************@read3.inet.fi... W.Davis wrote:
Group, I'm using ver 5 with winXP. I can access the test database, but can't
create a table. I can't create ANY database as I keep getting error 1044
(42000): Access denied for user: ' '@'localhost' to database 'mynewdatabase'. Can
you help?
Log in as root user. I assume you are currently logged in as test user (test user has no access to create databases).
If you are using mysql console program, and you have not set up a password for root user, you can log in as root like this:
mysql -u root This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: lkrubner |
last post by:
I have a webserver through Rackspace. I create a domain. I create an
FTP user. I upload some files. I create a database called
testOfSetupScript and then I create a database user named setup.
I...
|
by: Robin Tucker |
last post by:
I have some code that dynamically creates a database (name is @FullName) and
then creates a table within that database. Is it possible to wrap these
things into a transaction such that if any one...
|
by: SD |
last post by:
Hi,
Quick question, I have about 20 users in my local server and database. We
are looking to restore that database to a new server in a new network and
still be able to retain the database...
|
by: *no spam* |
last post by:
I want to move my Access 2K database into MSDE. The Access Upsizing
Wizard crashes (a known bug wi A2K), so I'm using the following
suggested method:
Access --> New --> Project (Existing...
|
by: Manzoorul Hassan |
last post by:
I just Installed MySQL v4.1.14 and had created a Database (from a
script). But I would like to redo the Database portion of it but am not
able to drop the Database. If I do a "show database;" I...
|
by: Hemant Shah |
last post by:
Folks,
I am using DB2 UDB 8.2 on AIX 5.1. How large of a bufferpool can you create?
I tried to create a 4GB bufferpool db2 complained that is cannot
allocate enogth memory. I have 16GB on this...
|
by: Robert McEuen |
last post by:
Using Access 97 on WinXP
I have data in a DB2 table that I'm trying to get into an identical
table in my backend db. Based on volume of data and frequency of
download, I'm trying to avoid...
|
by: Albretch |
last post by:
.. I am trying to create a database in a MS Access DB via JDBC drivers.
I have tried both sun.jdbc.odbc.JdbcOdbcDriver and ids.sql.IDSDriver
From some reason both drivers Exceptions tell me...
|
by: Larry Rebich |
last post by:
I am trying to use the sample web template that is distributed with Visual
Studio 2005 called 'Personal Web Site Starter Kit'. After running for awhile
it fails with the following message:
...
|
by: etuncer |
last post by:
Hello All,
I have Access 2003, and am trying to build a database for my small
company. I want to be able to create a word document based on the data
entered through a form. the real question is...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
| |