Setting Up New Mysql Accounts
I have followed the manual for MySQL 5.0 for adding new accounts to MySQL but it will not work for me. I am typing these commands on the root on the actual computer with Every time I input these following commands, the command just returns this:
mysql> Query OK, 0 rows affected (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON *.* TO 'myusername'@'localhost'
-> IDENTIFIED BY 'mypass' WITH GRANT OPTION;
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
-> ON mydatabase.*
-> TO 'myusername'@'localhost'
-> IDENTIFIED BY 'mypassword';
I've also tried this one
mysql> CREATE USER 'myusername'@'localhost' IDENTIFIED BY 'mypassword';
But it returns
mysql> ERROR (HY000): Opteration CREATE USER failed for 'myusername'@'localhost' .
View Complete Forum Thread with Replies
Related Forum Messages:
Setting Up Initial Accounts In MySQL
I'm a newbie to MySQL. In setting up my initial accounts, I see two anonymous users in the mysql database in the user table. My book says to delete them which I did, but I still see what looks like two root accounts. Is this normal? If not, which one do I delete? I see one doesn't yet have a password; should I delete the one without a password? First I'll log out and log back in as root to see if that other root user is a phantom or is really an account. Next, I'll need to add a few users, but I need to make sure this root thing is correct. Here's a screen shot of wht I did: mysql> use mysql Database changed mysql> select user.user from user; +------+ | user | +------+ | | | root | | | | root | +------+ 4 rows in set (0.02 sec) mysql> delete from user where user=''; Query OK, 2 rows affected (0.01 sec) mysql> select user.user from user; +------+ | user | +------+ | root | | root | +------+ 2 rows in set (0.00 sec)
View Replies !
MySql - Accounts
What privileges does a user need to be able to create new accounts? I have an account with all privileges including the grant privilege, but when I try to create a new user with this account, I always get an access denied error. I'm using an old mySql Version (3.22.32) and a windows-client with an ODBC connection. There is no problem to connect, select or update any data in my database, only with my superuser, only the creation of new user fail.
View Replies !
MySQL Accounts
When I installed mySQL I created administrator account with a different name to root and set a password. Having just had a look there's 5 accounts: root (host set to: localhost) root (host set to: %) localhost (host is blank) % (host is blank) my administrator account (host set to: %) Can I safely delete root, root, localhost and % accounts? All of my server applications user the administrator account I created.
View Replies !
MYSQL Password Accounts
I have been having problems with password accounts in MySQL. I'm setting up the environment for the first time. from the mysql website the intructions are to set the password on Windows: shell> mysql -u root mysql>SET password ......... My question is where do i access "shell>" to start off the code I have little expreience in writing in the command window so I do apologise if this question is overly remedial
View Replies !
USer Accounts Creation With MySQL
I am trying to create a website that uses ASP.NET interfacing wth a MySQL database, this is more of a Design based question (I think!). I need users to automatically register an ccount online and create entries within the tables in a specific database. How do I manage this, do i have to create a new user each time by the query GRANT? If so I am planning to have many users logging in to a big table that has a lot of other data for other users (they will be identofoable by an ID column i.e Joe_Bloggs). what do I set as permissions to that particular table, as potentially they could change someone elses information. I may just need a pointer to how you actually go about designing a system as I have described and manage all the users information to allow a good level of security and scalability for expanding the application at a later date. Is it better just to create a new table within the databse each time a new user is created as that way I would be able to grant that particular table (i.e. Joe_Bloggs_Table) the correct permmisions.
View Replies !
Db Accounts
Does anyone know of a good isp where I can pay for just the use of a mysql database? I don't know when my provider (pair nwetworks) is going to upgrade and I absolutely need the latest version with unicode support as I need to have many different scripts in the same table.
View Replies !
Accounts
also, can someone please tell me what is the relationship/difference/similarity and interaction betweeen: 1.phpmyadmin login/access 2.mysql login/access 3.database login/access if a user signs up on my website, how can i give him a separate db automatically upon sign up, with default tables and access to only his db with his login username and password? also, before accessing his own db, will he connect to the mysql server using a diff p/w?..how exactly will it work?
View Replies !
Mutiple Accounts
I am looking for a solution for this and havent been able to find it anywhere i think i am searching for the wrong keywords or strings... i want to be able to allow users to create there own database's in there account but limit the database's that they can create to a prefix on every data base (diffrent prefix for diffrent users)Also is it possible they can create users that only have access to the database's in the master account?.i am trying to stay out of the admin role as much as possible it's just internal office applications that staff can use mostly a sandbox so security is not an issue.
View Replies !
User Accounts With Passwords
I am able to connect to the database using users that are not password protected. After updating privileges to use passwords and changing login info(in a php document) I recieve the following error from the php document: Warning: mysql_query(): Access denied for user 'ODBC'@'localhost' (using password: NO) in c:inetpubwwwrootgindex.php on line 9 Warning: mysql_query(): A link to the server could not be established in c:inetpubwwwrootgindex.php on line 9 I am attempting to connect as 'test'@'localhost' with the password 'test'. If I remove the password, I can connect no problem.
View Replies !
User Accounts Not Recognized
I am the administrator and asks for my password (that's ok because I am the administrator). The downside is, no where did it ask me for a user name. I've tried using "root", because, well it is the root file and I am the administrator. Just to test this out, I set up another account and password. MySQL acknowledged it and going through and being set up correctly, but I can't log on as that person or access it through PHP. I was reading in the reference manual that GRANT files should be automatically set up. When I go into my MySQL file,I don't see anything there regarding grants or privileges or users. When I start writing PHP to create and access databases, how will it recognize me if I never set up a user name? Perhaps this should be in the PHP forum?
View Replies !
Sum, Union And Balancing Accounts
One of my clients has a very complex accounts system, which has issues that I've been brought in to fix. The first stage I want to start with is a report showing which transactions don't balance. Code:
View Replies !
Moving Data And Accounts When Upgrading
Before upgrading my directory structure looks like: /usr/local/myslq-4.0.21 /usr/local/myslq@ -> mysql-4.0.21 After I install an upgrade it looks like: /usr/local/mysql-4.0.21 /usr/local/mysql-4.1.12 /usr/local/mysql@ -> mysql-4.1.12 The upgrade instructions then say to run "mysql_fix_privilege_tables" but the privilege tables should not need fixing since the only thing in the mysql-4.1.12/data directory are the new "mysql" and "test" databases and they should not need fixing. Also none of my old user accounts and data are there. Am I supposed to do something to copy the old data directory to the new data directory and then fix the privilege tables? Something like "(cd mysql-4.0.21; tar cf -) | (cd mysql-4.1.12; tar xf -)"? Or should my data directory be independent of the mysql directory and used from each installation?
View Replies !
Backup/restore User Accounts
I have mysql 5.0.14? installed. I need to make a fresh installation of 5.0.18 (no update). I can create a backup of my database (export) and import it into the new version. But how can I migrate my useraccounts? The probem is, I tried re-creating a user with same pwd in the new version, assigned privileges to that user and the user to my freshly imported database, but when trying to access the DB using a script, it tells me that "user" has no access.
View Replies !
Connect To Database With Passworded Accounts
I am migrating my databases from mysql 4.0.x to 4.1.7 and i'm having the following problem: When i create accounts with passwords, i can't connect to databases with them. It only works with non-passworded accounts. I tried to put old_passwords=yes in my my.ini file, but it didn't work.
View Replies !
Adding New User Accounts :: Access Denied
I have read Ref Manual 5.9.2 Adding New User Accounts and 5.8.8 Causes of Access Denied. I am running SUSE 10.1: /usr/sbin/mysqld Ver 5.0.18 for suse-linux on i686 (SUSE MySQL RPM) This works: mysql -u root -ppassword mysql Using user root, from Python I can access sql, add data to tables, etc. but I want to set up other users and access mysql from other than localhost. I tried this (as suggested in 5.9.2): mysql> GRANT ALL PRIVILEGES ON *.* TO 'pwh'@'localhost' -> IDENTIFIED BY 'password' WITH GRANT OPTION; mysql> GRANT ALL PRIVILEGES ON *.* TO 'pwh'@'%' -> IDENTIFIED BY 'password' WITH GRANT OPTION; But this happens: mysql -u pwh -ppassword ERROR 1045 (28000): Access denied for user 'pwh'@'localhost' (using password: YES) Ref man 5.8.8 says if all else fails, reinstall from the source. I started to do that but got stuck. I would rather not if it can be avoided.
View Replies !
Number Of User Accounts For Large Database
I have a large database (816 tables with 11 fields each, each field could hold up to 50 entires) and I'd like to know if each table should have its own user account (created in Cpanel and used in the config file to access the database). May sound like a simple question to some but I need to know in case we have a lot of traffic and 1 user account is not "enough" for all visitors to access the database info.
View Replies !
Most Efficient Way Of Storing Data From Multiple Accounts
As part of a system I am putting together I need to allow users to create thier own accounts on my servers. Each user can create their own account, and then have their users register for it. Each account needs it data seperate from the others, a member registered for one account should not be able to view another account and a username registered with one account should still be available to the other accounts. The ways I have been looking at are: 1. Create a new database for every account created so that all users are kept in seperate databases. 2. Have one table for users, one for topics, one for posts etc and then associate each row within this table with the relevent account. So for example a user could register with the forum with the ID 4, so their user entry would be Userid: 234 Username: xxxx Password: xxxx Forumid: 4 Then when a new member registers with any account I simply check that there is not another user with the same account ID and username. Indexes on relevent fields in this system could help speed up huge tables. I expect to quickly have 20,000 plus accounts (and in theory it could go up to hundreds of thousands). I guess my question is which of these methods is better from a speed point of view once we get a large number of accounts and users. Also, are there restrictions on the number of fields in a table that could cause problems? Using MySQL by the way, on an Apache server.
View Replies !
How To Save Accounts Based On Variable Amounts Of Time
I'm currently building a website where users can signup for various accounts. An account may last 30 days, 12 months or 24 months. If a user's account is about to expire, an email notification is send, via a CRON Job. I want to save the different account types in the database, but I'm not sure how to save the duration of an account. If it was all months, I could simply save ཈' or པ' as an INT, but it also has an account for 30 days, which is more flexible. Edit: It would also be nice if I could ORDER BY duration..
View Replies !
Setting Up MySQL On Mac OS X
I'm a novice Unix user, and I can't get MySQL set up properly on my Mac. It seems to have installed OK, but when I try to run the mysql_install_ db script, I get errors. I can't set the root password either that the documentation tells me to. As background, I just want to use MySQL to work with databases and PHP and HTML to set up web pages for database input and output. I'm running MySQL on my own machine at home, and have no use for passwords or any other administrative functions. I'm just looking to use the program to set up and query databases. Can anyone point me to a way to avoid all the UNIX admin stuff and run the database? I can get in, but the mysql database doesn't appear when I hit SHOW DATABASES as the tutuorial says, and I can't access or create new databases. I think all this may have something to do with my user account on my machine, but I'm not savvy enough to know how to override permissions, be root, or any of that stuff. Any hints?
View Replies !
Setting Mysql
I'm setting up mysql server for the first time and after logging into the command prompt I setup a new super user and deleted the root user for security reasons. Now it seems I can't login to the server at all. MUST you have a root user to run a mysql server? If not, how can I login to do anything?
View Replies !
Why Dont Shared Hosting Accounts Provide Stored Procedures And Triggers?
i am searching for 3 days now for a reliable, fast hosting company, which supports stored procedures and triggers on mysql5. most of them dont support this, because mysql5 has a design-flaw in which it stores procedures and triggers on a root level-area (tables mysql information_schema). due this logic, most of the hosting companies wont allow you to create/run procedures and triggers. funny, that hosting companies forbid you to use new technologies and methods to build faster.
View Replies !
Re-setting Mysql As A Service
I installed mysql server 4.1 last month. When I installed it, I set it to run as a service to start automatically. However, for some reason, that no longer occurs. I can't even see the mysql service running from services viewer in win xp. I now have to manually start mysql server each time I reboot. Can someone please tell me how I can Re-set mysql to run as a service?? Or, if I re-install mysql, will it retain the db's already created??
View Replies !
Help With Setting Up A MYSQL Database
I’d like help with developing a mysql database please. The situation is as follows: There are 40 teachers at our institution. Each teacher teaches 4 lessons (I’ll call them: CW, EW, DSS and LNT) – CW and EW are taught to two classes, and DSS and LNT are taught to two different classes. There are 5 syllabus items for each lesson that need to be covered for each class. The course runs for 10 weeks. I’ve calculated the number of unique records will be 16000 The coverage of each week’s content depends largely on the level of the students, the teacher and/or any supplementary material used. On my php page, if a syllabus item is covered teachers need to check it as completed (checkbox). Any additions to the lesson need to be added to a comments field (textarea). Teachers should be able to log into to see their records (stored on the mysql database and accessed through php pages) and then be able to filter their records by week, class and lesson using drop down lists. The question I have is: What is the best way to set up the mysql database so that each record is unique so that I can accomplish the above? Fields: ID(int), content(text), teacher(text), course(text), week(int), completed(int) and comment(text) Running MySQL client version: 5.0.51b on Windows XP
View Replies !
Setting MySQL Host
I'm looking to grant access to a MySQL database based on a range of IPs. I did a search on the forums here and couldn't find exactly what I was looking for. The IP range is actually only 2 IP addresses but I'm sure there must be a way of setting the Host to accept something like: 123.123.123.*.Currently I can't test it as I don't have access to the web servers, but it someone could tell me the surefire way of doing this it will be one less worry for me .
View Replies !
Setting Up MySQL Administrator
I just downloaded MySQL Administrator and am trying to install it. I'm trying "localhost" and "root" for Server Host and Username, along with the default setting for Port, 3306. However, I don't have a clue what a "Stored Connection" is. What am I supposed to enter there?
View Replies !
Configuring/Setting Up MySQL 5
Im a complete newbie to mac os x. I downloaded and installed mySQL 5. I installed it and now i cant seem to connect. I have absolutely no idea what im doing. Im not familiar with os x termial commands. I need someone to email me and explain to me everything i need to do in order to create a user and successfully login using mySQL admin. I've been struggling with this for over a week. Ready to pull my hair out. And please dont refer me to online resources, ive read them all and still cant figure it out. I need a professional who can give me a step by step process to get this going.
View Replies !
Setting Priviledges On MySQL
having a problem setting up users on MySQL, my database is currently running using the default settings. I have scoured the documentation for both PHPMyAdmin and MySQL and am still none the wiser.
View Replies !
Setting Up The MySQL Password
I can't seem to see the page whan I am trying to set up the 'Setting Up the MySQL Password'. I know this is right at the start but all I get when I type in the Web browser http://127.0.0.1/myadmin is the sourcecode and not the actual log in page... I know it's something silly I have done or not done (I have installed the Apache / MySQL / PHP stuff over and over again, but it still does the same thing to me. The Apache services is running fine. The WinMySQLadmin is on green so I know that's fine. I think it's maybe an explorer thing? but I can't seem to get it.
View Replies !
Setting MYSQL Rules
i got table with one column of dates - time(). how i can set a rule inside the mysql -not on asp pages... the rule- take the maximum value and delete all the values that "smaller" than the maximum value, in 20 min
View Replies !
Setting Up MySQL On Mac > Leopard
PHP Code: $link = mysql_connect ("localhost" , "Cretaceous" , "Dinosauria") or die(mysql_error());mysql_select_db ("Trex", $link) or die(mysql_error()); and put it on a test page. When I preview it in a browser, it gives me the following error message: Code: Access denied for user 'Cretaceous'@'localhost' (using password: YES) I checked the privileges, as follows: User (Cretaceous), Host (%), Password (Yes), Global privileges (USAGE), Grant (No) It looks like my user name and password are OK. I changed the database name from Trex to trex (all lower case), but I get the same error message. Since the Privileges page lists the Host as %, rather than localhost, do I have to make some sort of change there? I replaced "localhost" with % in my database query but that doesn't work.
View Replies !
Setting Up MySQL Administrator (have WHM)
I would like to set up MySQL Administrator. (MySQL is taking up 50+ % of my CPU, and I'm not sure why...) I'm having difficulty connecting to my MySQL db. I'm fairly sure I have the correct username and password. For the host, I just used my server's IP and for the Port, I have 3306. When I try to connect, I receive the following error... MySQL Error Number 1130 Host '<IP address>' is not allowed to connect to this MySQL server. I tried adding <IP address> to the MySQL Access Hosts using WHM, but don't think it's working. In fact, I think when I initially tried it... my phpmyadmin stopped working and I had to go in manually to the config file and fix it up.
View Replies !
Setting MySQL Parameters Via PHPmyadmin
What is best selection for 'collation' parameter - for those, who need use two languages, latin(english) and cyrillic(russian) on website and need that mySQL handled and stored both languages correctly? What need be specified in "MySQL connection collation" field?
View Replies !
MySQL Performance - Option Setting
I set OPTION=3 in my connection string as recommended by MySQL (http://dev.mysql.com/doc/refman/5.0...parameters.html) for a VB application. OPTION=3 is Don't Optimised Column Width (1) and Return Matching Rows (2). I found this to be very slow on a database with just 27,000 records. It took approx. 12 seconds to read 27,000 records. When I change the OPTION to 8 (Allow Big Results), it took just 3 seconds to read 27,000 records. BUT now my application cannot update records anymore and getting random errors on transactions. I try setting OPTION=11 (all 3 options added together) and the speed went back to being slow.
View Replies !
Setting Up Mysql Tables For UNICODE
I am willing to setup my MySQL tables so they can hold international strings (English, French, German and Spanish). I understand that Unicode character coding is a good candidate to do so. Currently I use the default character set and it looks like it does not like characters such as "é", "ô" .etc... (they come up as strange characters probably indicating that the code of the character has been truncated). Is my understanding correct? If yes, could anyone lead me through on how to create such tables coding text as Unicode? I went through the MySQL administration guide but cannot get a clear understanding on how this is supposed to be performed. Ideally I would like to setup the MySQL *server* for it to process the tables with the Unicode character set *by default * (rather than specifying each tables one by one as using Unicode encoding).
View Replies !
Sorting Columns. Setting Up Mysql ?
Interested in setting up information in columns to sort in ascending and descending order. I'm hoping to set up a clickable image for both options. I know basic html design, I'm just not sure where to start in mysql. Not sure how to set up the table and where to link them to php pages.
View Replies !
Setting MySQL Variables At Start Using My.ini
I am battling to set the default datetime_format in my.ini, if i add the line i want to change the setting, the service refuses to start! The line i am adding is as follows: set-variable = datetime_format="%y/%m/%d %H:%i:%s" Am i doing something wrong here?
View Replies !
Setting Password For MySQL From WAMP?
A few months back I installed WAMP (one big installation of Apache, MySQL and PHP for Windows). The last week I'm busy with Portal development. As a result I'm trying to install Jetspeed-2. The installer of Jetspeed asked what Database I would like to use. As I installed WAMP I thought it wiser to stick to MySQL. When I started phpMyAdmin I saw the following message: "Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account." As it is some time since I installed WAMP I cannot remember what I need to do. I searched the install directory and found that the word password is contained in several .ini files (my-huge.ini, my-innodb-heavy-4G.ini, my-large.ini, my-medium.inim and my-small.ini, but not in my.ini). The format of the line is: #password= your_password I take it I need to remove the # at the start of the line, replace 'your_password' with a password of my choosing? But in what ini file? How does WAMP know what ini file to choose? In the same directory as the ini files I see a wampserver.conf file. In it there is an entry: $mysqlConf['mysqlConfFile'] = 'my.ini'; Does this entry make WAMP to choose for my.ini? I plan to use the WAMP/MySQL installation purely for development purposes.
View Replies !
Setting Up A MySQL Server With SBC Webhosting
So I got into my Database Tools section and all I have is this: * Documentation * File Importer * Monitor Table maintenance and testing * Schema Viewer View table definitions * Database Dumper Export table contents and definitions Special Notes: * Access to your MySQL Database will require that you supply your userid and password. * Download myodbc, a Windows 95/NT ODBC Client, from the MySQL Homepage. * For ODBC access use port 3306. There is NOTHING that tells me WHERE to access my MySQL Database, and myODBC does nothing for me because I don't know where my Database is (I've tried using it to in various ways and can't get anywhere). I have no idea what to do with that port number. Could someone help me out?
View Replies !
MySQL Setting Collation To Latin1_swedish_ci
No matter how I configure MySQL 4.1.9, I always end up with all of my tables having collation set to "latin1_swedish_ci". I have tried setting the collation to "latin1_general_ci" but my settings are ignored and all tables show up as "latin1_swedish_ci". The tables that were created have been created and all data inserted through a PHPMyAdmin SQL file export under a server running MySQL 4.0.22. Is there any way to fix this and what is might be causing it.
View Replies !
Setting Up PHP And MySQL To Work Togather.
I can't get MySQL and PHP to work. I've installed MySQL ver.5.0.3 or so on my PC (winXP) on my D: drive, after that i've installed Apache2 serv. also on the D: drive and afterward came PHP5 as a Apache module. I've tried testing if it works. Code:
View Replies !
Setting UP MySQL To Work With Dreamweaver And PHP
I'm trying to set up Dreamweaver to work with PHP and MySQL but cannot get Dreamweaver to recognize my database. I currently have PHP running under Microsoft IIS on my Windows machine and MySQL installed and running. I'm accessing it through MySQL Administrator and also MySQL-Front and don't have any problems connecting to the database in either of these programs. I've set up a DSN for the database, under ODBC Data Sources, and I'm using a virtual directory under IIS for the web pages I'm developing. When setting up a database connection though in Dreamweaver, I get an error message that says "An unidentified error has occurred" As far as I can tell, I have MySQL set up for Root access and also anonymous access. Any suggestions about what I'm missing to get this to work?
View Replies !
Setting Mysql Root Password On Mac
Am having problems setting the root password for the mysql server on my computer. I'm using Mac OS X with apache, php 5 and mysql 4.1 installed. I've tried using the terminal utility but I've had an error message reading:
View Replies !
Setting Root Password For MySQL
I'm Using the "Build Your Own Database Driven Website Using PHP and MYSQL" by Kevin Yank. On pg. 22 where the arguments new password are in parentheses, I typed in new password instead of my own new password ( I know that was dumb!). Anyway, when I quit the Mysql and start over I get the error: cannot login to local host password not excepted. How do I restart so that I can create a root password for Mysql?
View Replies !
Setting MySql Root Password
I feel a bit daft as I can't seem to get passed p21 of Database Driven Website by Kevin Yank. But I'm learning Ive got the latest copy and and want to follow it through to see what i can learn (lots I'm sure) Im on a mac osx and am trying to set the root password. He says to do this using terminal in the bin directory of my MySql installation. Where is it? i know basics about getting round terminal i.e changing directories and stuff.
View Replies !
|
TRACKER
